Developer Transformation Guide

Back Next

Mapping Configuration for a Dynamic Lookup Cache

If you use a Lookup with a dynamic cache, you must configure the mapping to update the dynamic lookup cache and write the changed rows to the target.

Complete the following steps to configure a mapping with a dynamic lookup cache:

Flag the input rows of the Lookup transformation for insert or update.: By default, the row type of all input rows is insert. Add an Update Strategy transformation before the Lookup transformation to specify different row types for the input rows.
Specify how the Integration Service handles the input rows for the dynamic cache.: Select the
Insert Else Update
or
Update Else Insert
options to process rows flagged for insert or update.
Create separate mapping pipelines for rows to be inserted into the target and updated in the target.: Add a Filter or Router transformation after the Lookup transformation to route insert and update rows into separate mapping branches. Use the value of the NewLookupRow to determine the appropriate branch for each row.
Configure the row type for output rows of the Lookup transformation.: Add an Update Strategy transformation to flag rows for insert or update.