What is Lookup transformation?
• It is a type of transformation that is used to get the relevant data by looking up the source qualifier or by the target.
• The lookup transformation is used to look up the data present in flat files,relational tables and views.
• There are various types of ports that are used for creating lookup transformation,there are
- Input port
- Output port
- Return ports
Curing configure dynamic caching, the Informatica Server inserts rows into the cache.
Lookup transformation is a passive transformation used to look up a source, source qualifier, or target to get the relevant data. Basically, it’s a kind of join operation in which one of the joining tables is the source data, and the other joining table is the lookup table.