3.11.1 Dynamic lookup transformation in IICS

Dynamic Lookup in Informatica Cloud :

1. In Static cache , the data in the lookup cache doesn’t change when the mapping task runs
2. But in case of Dynamic lookup , the cache gets updated as per the changes when the mapping task runs.
3. If you enable Dynamic cache, by default one new return port "NewLookupRow" will be included
4. The value for NewLookupRow can be 0, 1 or 2 .
5. NewLookupRow value will be 0 when there is no change in data,
it will be 1 when it's a new row, it will be 2 when there is a change in the record
6. The values of NewLookupRow can be used for flagging the record as insert/update..
7. When you enable dynammic lookup cache, a new tab "field mapping " gets added in properties.