Merge VS Merge Join

  

Merge	Merge Join
The data from 2 input paths are merged into one	The data from 2 inputs are merged based on some common key.
Works as UNION ALL	JOIN (LEFT, RIGHT OR FULL)
Supports 2 Datasets	Supports 1 Datasets
Metadata for all columns needs to be same	Key columns metadata needs to be same.
Data must be sorted.	Data must be sorted.
Does not support error handling	Does not support error handling