Data Integration Connectors
- Data Integration Connectors
- All Products
Property | Description
|
|---|---|
Connection
| Name of the lookup connection.
|
Object Type | Type of the lookup object. Select one of the following object types:
Default is Single Object. |
Lookup Object
| Name of the lookup object for the mapping.
|
Parameter | This property appears only if you select parameter as the object
type. A placeholder to dynamically assign values at run time for the lookup
object without the requirement to edit the task. Select an existing parameter for the lookup object or click
New Parameter to define a new parameter
for the lookup object.To overwrite the parameter at run time, select the Allow
parameter to be overridden at run time option. |
Multiple Matches
| Behavior when the lookup condition returns multiple matches. You can return first row, last row, any row, all rows, or report an error.
If you choose all rows and there are multiple matches, the Lookup transformation is an active transformation. If you choose any row, the first row, or the last row and there are multiple matches, the Lookup transformation is a passive transformation.
|