Cache Size for Partitioned Caches
If you have the Partitioning option, cache partitioning creates a separate cache for each partition that runs an Aggregator, Joiner, Rank, Lookup, or Sorter transformation. During cache partitioning, each partition stores different data in a separate cache. When the Data Integration Service uses cache partitioning for these transformations, the service divides the allocated cache size across the partitions.
For example, you configure the transformation cache size to be 100 MB. The Data Integration Service uses four partitions to run the transformation. The service divides the cache size value so that each partition uses a maximum of 25 MB for the cache size.