Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

SSIS - Difference between Unionall and Merge Join?

Nice?Vote!

1 Answer

Nice?Vote!
a) Merge transformation can accept only two inputs whereas Union all can take more than two inputs

b) Data has to be sorted before Merge Transformation whereas Union all doesn't have any condition like that.
answered 1 year ago by R (19,530 points)

Related questions