Here are the following uses of Lookup Transformation in Informatica:

  • To retrieve a value from the lookup table based on the value from the source.
  • To get multiple rows from a lookup table.
  • Retrieving a value and then using it for various calculations.
  • For relational or flat line lookup.
BY Best Interview Question ON 16 Jun 2020