The Integration Service handles shared lookup caches differently depending on whether the cache is static or dynamic:
If two Lookup transformations share a static cache, the Integration Service does
allocate additional memory for shared transformations in the same pipeline stage. For shared transformations in different pipeline stages, the Integration Service
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.
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.