Google BigQuery Connectors

Back Next

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.

Add a Lookup transformation in a mapping.

On the

General

tab of the Lookup transformation, enable the

Unconnected Lookup

option.

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.

The image shows the Incoming Fields tab of the Lookup transformation where you can add an incoming field to the Lookup transformation.

In the

Lookup Object

tab, import the lookup object.

The

Multiple Matches

property value

Return all rows

in an unconnected lookup is not supported.

Designate a return value.

You can pass multiple input values into a Lookup transformation and return one column of data.

Data Integration

returns one value from the lookup query. Use the return field to specify the return value.

The image shows the Lookup Condition tab of the Lookup transformation where you can pass multiple input values into a Lookup transformation and return one column of data.

Configure a lookup expression in another transformation.

Provide 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.