Amount of memory that the Data Integration Service allocates to the data cache for the transformation at the start of the mapping run. Select Auto to have the Data Integration Service automatically calculate the memory requirements at run time. Enter a specific value in bytes when you tune the cache size. Default is Auto.

Amount of memory that the Data Integration Service allocates to the index cache for the transformation at the start of the mapping run. Select Auto to have the Data Integration Service automatically calculate the memory requirements at run time. Enter a specific value in bytes when you tune the cache size. Default is Auto.

Directory where the Data Integration Service creates the index cache files and data cache files. Verify that the directory exists and contains enough disk space for the cache files.

Enter multiple directories separated by semicolons to increase performance during cache partitioning. Cache partitioning creates a separate cache for each partition that processes the transformation.

Default is the CacheDir system parameter. You can configure another system parameter or user-defined parameter for this property.

Indicates that input data is presorted by groups. Choose Sorted Input to join sorted data. Using sorted input can increase performance.

Specifies the sort order of the master source data. Choose Ascending if the master source data is in ascending order. If you choose Ascending, also enable sorted input. Default is Auto.