Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Amazon Redshift connectors
  3. Part 2: Data Integration with Amazon Redshift V2 Connector
  4. Part 3: Data Integration with Amazon Redshift Connector

Amazon Redshift Connectors

Amazon Redshift Connectors

Configure dynamic lookup cache

Configure dynamic lookup cache

You can configure a dynamic lookup cache to keep the lookup cache synchronized with the Amazon Redshift target.
Enable the Dynamic lookup cache field in the Lookup transformation advanced properties. By default, this field is disabled and represents static cache.
When you enable lookup caching, a
mapping
task builds the lookup cache when it processes the first lookup request. If the cache is static, the data in the lookup cache does not change as the mapping task runs. If the task uses the cache multiple times, the task uses the same data. If the cache is dynamic, the task updates the cache based on the actions in the task, so if the task uses the lookup multiple times, downstream transformations can use the updated data.
Based on the results of the lookup query, the row type, and the Lookup transformation properties, the
mapping
task performs one of the following actions on the dynamic lookup cache when it reads a row from the source:
Inserts the row into the cache
The
mapping
task inserts the row when the row is not in the cache. The
mapping
task flags the row as insert.
Updates the row in the cache
The
mapping
task updates the row when the row exists in the cache. The
mapping
task updates the row in the cache based on the input fields. The
mapping
task flags the row as an update row.
Makes no change to the cache
The
mapping
task makes no change when the row is in the cache and nothing changes. The
mapping
task flags the row as unchanged.
For information about dynamic lookup cache, see
Transformations
in the Data Integration help.