Configure the cache size to specify the amount of memory allocated to process a transformation. The amount of memory you configure depends on how much memory cache and disk cache you want to use.
If the cache size isn't big enough,
Data Integration
processes some of the transformation in memory and pages information to cache files to process the rest of the transformation. Each time
Data Integration
pages to a cache file, performance slows.
If the mapping contains a transformation that uses a cache, and you run the task on a machine with sufficient memory, increase the cache sizes to process the transformation in memory.