Transformations > Lookup Transformation > Lookup Object
  

Lookup Object

Configure the lookup object and the multiple match behavior on the Lookup Object tab of the Properties panel.
When you configure a lookup, 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 lookup object options:
Lookup Object Option
Description
Connection
Name of the lookup connection.
Lookup Object
Name of the lookup file, table, or object.
Formatting Options
File formatting options which are applicable if the lookup object is a flat file.
Opens the Formatting Options dialog box to define the format of the file. Configure the following file format options:
  • - Delimiter. Delimiter character.
  • - Text Qualifier. Character to qualify text.
  • - Escape character. Escape character.
  • - Field labels. Determines if the task generates field labels or imports labels from the source file.
  • - First data row. The first row of data. The task starts the read at the row number that you enter.
Multiple Matches
Behavior when the lookup condition returns multiple matches. You can return all rows, any row, the first row, the last row, or 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.
For Salesforce objects, you can return any row or return an error.
Lookup Object
Name of the lookup file, table, or object.