When you use a dynamic lookup cache, define the row type of the rows entering the Lookup transformation as either insert or update. You can define some rows as insert and some as update, or all insert, or all update. By default, the row type of all rows entering a Lookup transformation is insert. You can add an Update Strategy transformation before the Lookup transformation to define the row type as update.

The Integration Service either inserts or updates rows in the cache, or does not change the cache. By default, the Lookup transformation inserts a row in the cache when the row type is insert, and updates a row when the row type is update.

However, you can configure the following Lookup properties to change how the Integration Service handles inserts and updates to the cache:

You can configure the Lookup transformation to synchronize the Lookup source and the dynamic cache. When you synchronize the Lookup source and the cache, the Lookup transformation inserts rows directly in the Lookup source. You do not pass insert rows to the target. Use this configuration to run multiple sessions with Lookup transformations that insert rows to the same target.