Difference and similarity between merge and merge join transformation

There are following difference in merge and merge join.

	Merge Transofrmations	Merge Join Transformation
	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	1 Dataset
Columns	Metadata for all columns needs to be same	Key columns metadata needs to be same.
Pre-requisites	Data must be sorted. Merged columns should have same datatype i.e. if merged column is EmployeeName with string of 25 character in Input 1, it can be of less than or equal to 25 characters for merging to happen.	Data must be sorted. Merged columns should have same datatype i.e. if merged column is EmployeeName with string of 25 character in Input 1, it can be of less than or equal to 25 characters for merging to happen.
Limitations	Only 2 input paths can be merged. Does not support error handling.	Does not support error handling.
Use	Merging of data from 2 data source Can create complex datasets using nesting merge transformation,	When data from 2 tables having foreign key relationship needs to present based on common key.