What are the Lookup Caches ?

When configuring a lookup cache, you can specify any of the following options: 

• Persistent cache
• Recache from lookup source
• Static cache
• Dynamic cache
• Shared cache

 Dynamic cache: When you use a dynamic cache, the PowerCenter Server updates the lookup cache as it passes rows to the target.

If you configure a Lookup transformation to use a dynamic cache, you can only use the equality operator (=) in the lookup condition.

NewLookupRow Port will enable automatically.

NewLookupRow Value	Description
0	The PowerCenter Server does not update or insert the row in the cache.
1	The PowerCenter Server inserts the row into the cache.
2	The PowerCenter Server updates the row in the cache.

Static cache: It is a default cache; the PowerCenter Server doesn’t update the lookup cache as it passes rows to the target.

Persistent cache: If the lookup table does not change between sessions, configure the Lookup transformation to use a persistent lookup cache. The PowerCenter Server then saves and reuses cache files from session to session, eliminating the time required to read the lookup table.