To configure an unconnected Lookup transformation, select the
option, add incoming fields, configure the lookup condition, and designate a return value. Then configure a lookup expression in a different transformation.
tab of the Lookup transformation, enable the
Create the incoming fields.
tab of the Lookup transformation, create an incoming field for each argument in the :LKP expression. For each lookup condition you plan to create, you need to add an incoming field to the Lookup transformation. You can create a different field for each condition, or use the same incoming field in more than one condition.
Designate a return value.
You can pass multiple input values into a Lookup transformation and return one column of data.
can return one value from the lookup query. Use the return field to specify the return value.
Configure a lookup expression in another transformation.
Supply input values for an unconnected Lookup transformation from a :LKP expression in a transformation that uses expressions such as an Expression, Aggregator, Filter, or Router transformation. The arguments are local input fields that match the Lookup transformation input fields used in the lookup condition.