Informatica Transformations – Part 3
Lookup Transformation: Lookup transformation is Passive and it can be both Connected and UnConnected as well. It is used to look up data in a relational table, view, or synonym. Lookup definition can be imported either from source or from target tables. For example, if we want to retrieve all the sales of a product…