Diffrence Between Merge and Merge Join

Merge:

• Using Merge Transformation, We can combine two sorted data sets into single data set.
• The Merge Transformation similar to 'Union all'.
• The two data sets, Number of columns and data types should match.

Merge Join:

• Using Merge Join Transformation, We can Perform 'Join' Operation using two sorted data sets.
• We can perform 'Inner Join, Left Outer and Full Outer Join.
•  The two data sets, number of columns and data types can be differ but the Key columns (Using to join two data sets) data types should match.