Tuesday, June 10, 2014

Difference Between Merge and Merge Join in SSIS


Merge Transformation
Merge  JOIN  Transformation
Data from 2 input paths are merged into one    
The data from 2 inputs are merged with common column
Works as UNION ALL
JOIN (LEFT, RIGHT OR FULL)
Supports 2 Datasets
1 Dataset
Metadata for all columns needs to be same
In this Key column data type need to be same
Does not support error handling
Does not support error handling.

 

No comments:

Post a Comment