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.

BY Best Interview Question ON 16 Jun 2020