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

Rules and guidelines for configuring lookup transformations

Rules and guidelines for configuring lookup transformations

Consider the following rules and guidelines when you configure an Amazon Redshift lookup transformation:
  • You cannot use unconnected lookups in
    elastic mappings
    .
  • You cannot configure a dynamic lookup cache in
    elastic mappings
    .
  • You cannot use the SQL query property for uncached lookups.
  • A Lookup transformation in an
    elastic mapping
    , with the
    On Multiple Matches
    property configured as
    Report Error
    , runs successfully without displaying an error message.