S.no JOINER TRANSFORMATION LOOKUP TRANSFORMATION
1. It is usually used for joining data from two more tables or source qualifiers. It is used on a single query or table record for searching records that match with incoming records.
2. The join type can be left, right, inner or outer join. The Lookup can be connected or unconnected transformation.
3. It is used when the table size is large. It is used when the table size is not too large.
BY Best Interview Question ON 16 Jun 2020