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.
SQL Server Interview Questions · · · ·