When the Data Integration Service uses cache partitioning for Aggregator, Joiner, Rank, Lookup, and Sorter transformations, the service divides the cache size across the partitions.
You configure the cache size in the transformation advanced properties. You can enter a numeric value in bytes, or you can select
Auto
to have the Data Integration Service determine the cache size at run time.
If you enter a numeric value, the Data Integration Service divides the cache size across the number of transformation threads at run time. For example, you configure the transformation cache size to be 2,000,000 bytes. The Data Integration Service uses four threads to run the transformation. The service divides the cache size value so that each thread uses a maximum of 500,000 bytes for the cache size.
If you select
Auto
, the Data Integration Service determines the cache size for the transformation at run time. The service then divides the cache size across the number of transformation threads.