ODBC Connector Guide > Mappings and Mapping Configuration Tasks with ODBC Connector > ODBC Lookups in Mappings
  

ODBC Lookups in Mappings

You can create lookups for objects in ODBC connection. You can retrieve data from an ODBC lookup object based on the specified lookup condition.
When you configure a lookup in ODBC, you select the lookup connection and lookup object. You also define the behavior when a lookup condition returns more than one match.
The following table describes the ODBC lookup object properties that you can configure in a Lookup transformation:
Lookup Object Properties
Description
Connection
Name of the lookup connection.
Source Type
Type of the source object. Select Single Object or Parameter.
Lookup Object
Name of the lookup object for the mapping.
Parameter
The parameter for the lookup object. Create or select the parameter for the lookup object.
Note: The parameter property appears only if you select parameter as the source type.
Multiple Matches
Select Return first row, Return last row, Return any row, Return all rows or report error.
Filter
Not supported.
Sort
Not supported.
Advanced
Not supported.

Rules and Guidelines for ODBC Lookups

When possible, use a native connection instead of an ODBC connection for lookups. For example, to perform a lookup on Oracle, use an Oracle connection.