Diffrence betwee Lookup, Fuzzy Lookup and Fuzzy Grouping

Look-Up:
           Using Lookup Transformation we can find the exact matched records.

Fuzzy Lookup:
           Using Fuzzy Lookup Transformation, we can find the percentage matches between two strings.

Fuzzy Grouping:


           Using Fuzzy Grouping Transformation, we can find the duplicate records.

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.