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

Configuring an unconnected Lookup transformation

Configuring an unconnected Lookup transformation

To configure an unconnected Lookup transformation, select the
Unconnected Lookup
option, add incoming fields, configure the lookup condition, and designate a return value. Then configure a lookup expression in a different transformation.
  1. Add a Lookup transformation in a mapping.
  2. On the
    General
    tab of the Lookup transformation, enable the
    Unconnected Lookup
    option.
  3. On the
    Incoming Fields
    tab of the Lookup transformation, create an incoming field for each argument in the :LKP expression.
    For each lookup condition you create, add an incoming field to the Lookup transformation.
  4. In the
    Lookup Object
    tab, import the lookup object.
    You must select the
    Multiple Matches
    property value
    Report error
    in the unconnected lookup for pushdown optimization to work.
    When you select
    Report error
    for a lookup object and multiple matches are encountered in the lookup table, all the matches are included in the target for pushdown optimization.
  5. Designate a return value.
    You can pass multiple input values into a Lookup transformation. and return one column of data. The Secure Agent returns the value from the lookup query.
  6. Specify the field that you want the Secure Agent to return.
  7. Configure a lookup expression in another transformation.
    Supply input values for an unconnected Lookup transformation from a :LKP expression in a transformation that uses an Expression transformation. The arguments are local input fields that match the Lookup transformation input fields used in the lookup condition.
  8. Map the fields with the target.