Dynamic Lookup

Dynamic Lookup Cache Overview

The dynamic cache represents the data in the target. The Integration Service builds the 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.

When the Integration Service reads a row from the source, it updates the lookup cache by performing one of the below action:

·         Inserts the row into the cache: In case the source row is not in the cache then it will add the row to cache as insert type.

·         Updates the row in the cache: In case the source row exists in the cache and if there is change in data for those columns compared for change then it will add the row to cache as update type.

·         Makes no change to the cache: In case the row exists in the cache and if there is no change in data for those columns compared for change then it will add the row to cache as the row as unchanged.

The Integration Service either inserts or updates the cache or makes no change to the cache, based on the results of the lookup query, the row type, and the Lookup transformation properties you define.

Setting for Dynamic Lookup Cache:

1. Input, Output and Compare (Associated Expression) Columns

2. Lookup Conditional Columns

3. Properties required to configure dynamic lookup cache