Dynamic lookup cache changes while the
Integration Service processes the lookup. The Integration Service builds the
dynamic lookup cache when it processes the first lookup request. It queries the
cache based on the lookup condition for each row that passes into the transformation.
The Integration Service updates the lookup cache when it processes each row.
Based on the
results, the Integration Service performs one of the following actions on the
dynamic lookup cache when it reads a row from the source:
Inserts the row into the cache The Integration
Service inserts the row when the row is not in the cache and you configured the
Lookup transformation to insert rows into the cache. The Integration Service
flags the row as insert.
Updates the row in the cache The Integration
Service updates the row when the row exists in the cache and you configured the
Lookup transformation to update rows in the cache. The Integration Service
flags the row as an update row.
Makes no change to the cache The Integration
Service makes no change when the row exists in the cache and you configured the
Lookup transformation to insert new rows only. Or, the row is not in the cache
and you specified to update existing rows only. Or, the row is in the cache, but
based on the lookup condition, nothing changes. The Integration Service flags
the row as unchanged.
As soon as you create a dynamic lookup, Informatica adds one extra port to the lookup. The New Port is
NewLookupRow The
NewLookupRow property can contain one of the following values:
0 = No update to the
cache.
1 = Insert row into
cache.
2 = Update row in
cache.
Scenario
Lookup and insert
the new Customer records
*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.
No comments:
Post a Comment