Static cache.

If two Lookup transformations share a static cache, the Integration Service does

not

allocate additional memory for shared transformations in the same pipeline stage. For shared transformations in different pipeline stages, the Integration Service

does

allocate additional memory.

Static Lookup transformations that use the same data or a subset of data to create a disk cache can share the disk cache. However, the lookup keys may be different, so the transformations must have separate memory caches.

Dynamic cache.

When Lookup transformations share a dynamic cache, the Integration Service updates the memory cache and disk cache. To keep the caches synchronized, the Integration Service must share the disk cache and the corresponding memory cache between the transformations.