NewLookupRow.

The Designer adds this port to a Lookup transformation configured to use a dynamic cache. Indicates with a numeric value whether the Integration Service inserts or updates the row in the cache, or makes no change to the cache. To keep the lookup cache and the target table synchronized, pass rows to the target when the NewLookupRow value is equal to 1 or 2.

Associated Expression.

Associate lookup ports or the associated ports with an expression, an input/output port, or a sequence ID. The Integration Service uses the data in the associated expression to insert or update rows in the lookup cache. If you associate a sequence ID, the Integration Service generates a primary key for inserted rows in the lookup cache.

Ignore Null Inputs for Updates.

The Designer activates this port property for lookup/output ports when you configure the Lookup transformation to use a dynamic cache. Select this property when you do not want the Integration Service to update the column in the cache when the data in this column contains a null value.

Ignore in Comparison.

The Designer activates this port property for lookup/output ports not used in the lookup condition when you configure the Lookup transformation to use a dynamic cache. The Integration Service compares the values in all lookup ports with the values in their associated input ports by default. Select this property if you want the Integration Service to ignore the port when it compares values before updating a row.

Update Dynamic Cache Condition

. Allow the Integration Service to update the dynamic cache conditionally. You can create a boolean expression that determines whether to update the cache for an input row. Or, you can enable the Integration Service to update the cache with an expression result for an input row. The expression can contain values from the input row or the lookup cache.