Saturday, October 1, 2011

New lookup port in Lookup transformation using dynamic cache

New lookup port is one of the properties when we configure lookup transformation using dynamic cache

Basically, new lookup port has the numeric values of (0,1,2)
New lookup port with the numeric value '0' means tat Informatica server will not update or insert the row in the cache.
New lookup port with the numeric value '1' means tat Informatica server will insert the row into the cache.
New lookup port with the numeric value '2' means tat Informatica server will updates the row into the cache.

Which scenarios Newlookup port has been used?


Cache: Dynamic cache in Lookup transformation
Transformations: Lookup transformations,Update strategy transformation, filter transformation

By using this New lookup port values, we can pass some rows through filter to drop or use it,
Also we can pass some rows through updatestrategy to update some table.


Associated lookupport, Ignore NullInputs  for updates, Ignore in Comparison are others properties along with New lookup port.
Lookup newport pic below:




No comments:

Post a Comment