Property | Description |
|---|---|
Connection | Name of the lookup connection. |
Source Type | Source type. For database lookups, the source type can be single object or parameter. For flat file lookups, the source type can be single object, file list, command, or parameter. |
Lookup Object | If the source type is a single object, this property specifies the lookup file, table, or object. If the source property is a file list, this property specifies the text file that contains the file list. If the source type is a command, this property specifies the sample file from which Informatica Cloud imports the return fields. |
Parameter | If the source type is a parameter, this property specifies the parameter. |
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. |
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:
|
Command | If the source type is a command, this property specifies the command that generates the file list. |