You can configure the index and data cache sizes for a Joiner transformation session properties.

When you use 1:

n

partitioning, the Integration Service replicates the memory cache for each partition. Each partition requires as much memory as the total requirements for the transformation. When you configure the cache size for the Joiner transformation with 1:

n

partitioning, set the cache size to the total requirements for the transformation.

When you use

n

:

n

partitioning, each partition requires a portion of the total memory required to process the transformation. When you configure the cache size for the Joiner transformation with

n

:

n

partitioning, calculate the total requirements for the transformation, and then divide it by the number of partitions.

You can use the cache calculator to determine the cache size required to process the transformation. For example, you use the cache calculator to determine that the Joiner transformation requires 2,000,000 bytes of memory for the index cache and 4,000,000 bytes of memory for the data cache. You create four partitions for the pipeline. If you use 1:

n

partitioning, configure 2,000,000 bytes for the index cache and 4,000,000 bytes for the data cache. If you use

n

:

n

partitioning, configure 500,000 bytes for the index cache and 1,000,000 bytes for the data cache.

The following table describes the input you provide to calculate the Joiner cache sizes:

Enter the input and then click Calculate to calculate the data and index cache sizes. The calculated values appear in the Data Cache Size and Index Cache Size fields.