Question

What is Lookup transformation?

Answer 1

It is used for looking up data in a relational table through mapping. Lookup definition from any relational database is imported from a source which has tendency of connecting client and server. One can use multiple lookup transformation in a mapping.

Answer 2

To get the relevant data or information, the Lookup transformation is used to find a source qualifier, a target, or other sources. Many types of files can be searched in the Lookup transformation like for example flat files, relational tables, synonym, or views, etc. The Lookup transformation can be cited as active or passive. It can also be either connected or unconnected. In mapping, multiple lookup transformations can be used. In the mapping, it is compared with the lookup input port values.

The following are the different types of ports with which the lookup transformation is created:

1. Input port
2. Output port
3. Lookup ports
4. Return port