Monday, April 30, 2018

Difference between Merge and Union All Transformation in SSIS (SQL Server Integration Services)

Merge Union All
Accept two datasets only for input Accept more than two datasets for input
Requires both datasets to be sorted Does not required sorted input
Semi blocking Transformation Semi blocking Transformation

No comments:

Post a Comment