What is the difference between Joiner and Lookup transformation in Inf

What is the difference between Joiner and Lookup transformation in Informatica?

Answer»

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.