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