You can share one or more static caches with a dynamic lookup. If a dynamic lookup shares the cache with a static lookup in the same mapping, the static lookup reuses the cache created by the dynamic lookup.

You cannot share a cache between dynamic lookups.

If you configure multiple Lookup transformations to rebuild a persistent lookup cache, the Integration Service builds the cache for the first Lookup transformation, and then shares the persistent lookup cache for the subsequent Lookup transformations.

If you do not configure the first Lookup transformation to rebuild a persistent lookup cache, but you configure a subsequent Lookup transformation to rebuild the cache, the transformations cannot share the cache. The Integration Service builds the cache when it processes each Lookup transformation.

The lookup/output ports for subsequent Lookup transformations must match or be a subset of the ports in the Lookup transformation that the Integration Service uses to build the cache. The order of the ports do not need to match.

Lookup transformations that share the cache must have the following characteristics:

The Lookup transformations must use the same ports in the lookup condition.
The Lookup transformations must use the same SQL override if one is used.
Lookup caching must be enabled in all Lookup transformations.
The Lookup transformations must use the same type of lookup source.
All relational Lookup transformations must use the same database connection.
The Lookup transformations must use the same lookup table name.
The structure of the cache for all Lookup transformations must be compatible.