The Merge Transformation is similar to the Union All but it only takes two data sources and the data sources must be sorted.
The Merge Join does either an Inner, Left or Full join on the specified columns to join on from the data sources. Once again, the data source must be sorted before performing the transformation.