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.
Select the lookup source from the mapping inventory.
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.
Select the lookup source from the mapping inventory.
If your organization administrator has configured Enterprise Data Catalog integration properties, and you have added objects to the mapping from the
Data Catalog
page, you can select the lookup source from the
Inventory
panel. If your organization administrator has not configured Enterprise Data Catalog integration properties or you have not performed data catalog discovery, the
Inventory
panel is empty. For more information about data catalog discovery, see
Mappings
.
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.
You must also specify the transformation behavior when the lookup returns multiple matches.