How many outputs can Aggregate tranform have in a Data Flow task?
By default Aggregate transform has one output. In case in the same aggregate we want to get group by on 2 separated group of columns or group by and count disctinct in the same step, we can do this in Aggregate transform. To do this goto the Aggreagate transform Editor, click Advance and add another output. Note: This will not be a parallel execution, this can be discussed in advance topic.
Read More.. [32134 clicks]
Published under: SQL Server Interview Questions · · · ·