Aggregator Transformation Advanced Properties

Cache Directory

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.

Data Cache Size

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.

Index Cache Size

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.

Sorted Input

Indicates that input data is presorted by groups. Select this option only if the mapping passes sorted data to the Aggregator transformation.

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.

Related Topics:
• Cache Size