You can configure the cache size for a transformation in the session properties. When you configure the cache size, you specify the total requirements for the transformation, unless the Integration Service uses cache partitioning.
You configure the cache size differently if the Integration Services uses cache partitioning. To calculate the cache size when the Integration Service uses cache partitioning, calculate the total requirements for the transformation, and divide by the number of partitions.
To configure the cache size in the session:
In the Workflow Manager, open the session.
Click the Mapping tab.
Select the mapping object in the left pane.
The right pane of the Mapping tab shows the object properties where you can configure the cache size.
Use one of the following methods to set the cache size:
Enter a value for the cache size, click OK, and then skip to step Steps to Configure the Cache Size. If you enter a value, all values are in bytes by default. However, you can enter a value and specify one of the following units: KB, MB, or GB. If you enter the units, do not enter a space between the value and unit. For example, enter 350000KB, 200MB, or 1GB.