Informatica Common Components Lookup's eight find cache

You can configure the Lookup transformation to find files or tables in cache. PowerCenter will establish a cache in memory when processing the first data row in the cache lookup transformation. It allocates cache area memory based on the amount that you configure in the conversion or session characteristics. PowerCenter stores the condition value in the index cache area, and the output value is stored in the data cache area. PowerCenter will query the cache for each row entered into the transformation.

By default, PowerCenter also creates cache files in the $PMCacheDir. If the data does not fit in the memory cache area, PowerCenter stores the overflow value in the cache file. When the session is complete, PowerCenter frees the cache area memory and deletes the cache file unless you configure the Lookup transformation to use a persistent cache.

When you configure the find cache, you can specify any of the following options:

• Permanent Cache

• To re-cache from a lookup source

• Static cache

• Dynamic cache

• Shared cache

Note: You can only use dynamic caching for relationship lookups.

Informatica Common Components Lookup's eight find cache