Transformations

Back Next

Lookup object

The Lookup object is the source object that

Data Integration

queries when it performs the lookup. The lookup object is also called the lookup source.

Select the lookup source on the

Lookup Object

tab of the Properties panel. The properties that you configure for the lookup source vary based on the connection type

The following image shows the

Lookup Object

tab for a relational lookup:

Lookup object details where you configure the connection, source type, lookup object, and multiple match behavior.

You can select the lookup source in the following ways:

Select the connection and lookup object.: In the
Lookup Object Details
area, select the connection, source type, and lookup object. You can also create a new connection.
Use a parameter.: You can use an input parameter to define the connection or lookup object when you run the mapping task. For more information about parameters, see
Mappings
.
Use a custom query.: You can use a custom query to reduce the number of columns to query. You might want to use a custom query when the source object is large.