What is the use of lookup in Informatica?

1.	What is the use of lookup in Informatica?
Answer» In Informatica, the LOOKUP is basically a massive TRANSFORMATION that is used for looking up any source, source qualifier, or any TARGET for getting relevant data. To put it down simply, it is a type of JOIN operation where one of the JOINING tables is the data source, and the other is the lookup table.

Discussion