What is Lookup Transformation in Informatica?
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
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview 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...