Types of Lookup Tranformation

Types of Lookup Tranformation

There are two types of lookup transformation

Connected Lookup Transformtion


1. Input is obtained from mapping pipeline
2. It can return multiple values
3. It supports both static and dynamic cache
4. Multiple lookup instance is created in the mapping.
5. Returns a default value when no records.


Unconnected Lookup Transformation

1. Input is obtained from :LKP function
2. Returns only one value
3. It supports only static cache
4. One lookup instance is used in the mapping.
5. Return null value when no record.