Differentiate between joiner and LookupTransformation.

Join Transformation

Lookup Transformation

• It uses only = operator to match column data.
• It has four type of joiner :
• Normal join
• master outer join
• detail outer join
• Full outer join
  

• It uses =,>=,<=, != operator.
• It work like Left outer join only.
  

Joiner is active and connected transformation

Lookup is active/passive and connected or unconnected transformation.

Joiner transformation is used to usually to join data coming from two separate tables or source qualifiers.

Look up transformation can be used on a single table or a query to search for records that match incoming Records