Property | Description |
|---|---|
Connection | Name of the source connection. |
Source type | Select Single Object. |
Lookup Object | Select a Standard Search Record object. |
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. |
Advanced Property | Description |
|---|---|
Page Size | Page size used to get data from a source. Minimum value is 5. Maximum value is 1000. Default value is 100. |
Maximum Records to Read | Maximum number of records read from the source. For example, a value of 100 means that the Secure Agent reads 100 records from the source. The default value is 0, which means that the Secure Agent reads all records. |
Maximum number of concurrent threads | Number of concurrent threads. Specify the number of concurrent threads that you want to use. To optimize performance results with concurrent threads, your administrator might need to adjust the heap size. For example, a heap size of 512 MB for 10 threads might optimize performance results. Default value is 4. |
Tracing Level | Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal. |
Lookup Caching Enabled | Determines whether to cache lookup data during the runtime session. When you enable caching, the Data Integration Server queries the lookup source once and caches the values for use during the session. Caching the lookup values can improve session performance. When you disable caching, each time a row passes into the transformation, a SELECT statement gets the lookup values. Default is enabled. Note: You need to disable caching to configure mapping in a lookup. |