Specify a Default Value to assign to the value attribute, if a key value was not found in the lookup table.
If Use Key Value is activated, the key value will be assigned to the value attribute instead of the default, if the lookup does not find a match.
If activated, the lookup will also be performed for empty or NULL key values; otherwise, the selected default method applies.
Enter the estimated number of lookup records to optimize memory allocation and lookup performance.
The entire result set is loaded into cache memory and remains unchanged until the transformation process finishes. Choosing an appropriate value for Lookup Size allows allocating memory in one piece while a low value will cause the program to allocate memory incrementally.
Refer to “Entering database connection parameters” for more information on the previous and the following properties:
Database
Schema
Standardize Data Format
Database Options
