What is Lookup Transformation in Informatica?

Kiran Sweet
Kiran Sweet

Posted On: Dec 31, 2020

 

Lookup transformation is a kind of join operation. Lookup transformation is a passive transformation. It has one of the joining tables as the source data and the other joining table known as the lookup table. Basically, It is used to look up a source, source qualifier, or target to get the relevant data. It also returns the result of the lookup to the target or another transformation.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Cognizant Informatica interview questions

    What is Star schema in informatica?

    Star Schema in a data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. As its structure resembles a star so it is known as a star schema....

    Cognizant Informatica interview questions

    What is snow flake schema ?

    In the data warehouse, Snowflake Schema is a logical arrangement of tables in a multidimensional database...

    Cognizant Informatica interview questions

    How do remove duplicates values in informatica from DB and Flat file?

    distinct property(keyword) is used to eliminate duplicate rows in Informatica from a database and a flat-file. We can eliminate duplicate rows from the flat-file by using group by function in an aggr...