Cache memories in Informatica

All the people know that there are three different types of cache memories viz..

1.Static Cache,

2.Dynamic Cache,

3.Persistent Cache.

Let me explain how exactly these caches work and when they should be used.

Static Cache

This has session lifetime and once the session is complete,the cache is deleted. It brings entire records from the database into the cache. Its default cache for lookup tables. Informatica takes time to create cache and affects performance. It should be used only when the tables used in the mapping aren’t used anywhere in the workflows.

Dynamic Cache

It should be used when they databases are large. The principle behind it is,it will bring records one by one into the cache from the database. If the record is present already(Identified using key columns),then the particular record is not brought into the cache. It will help when the database has lot of redundant records.

Persistent Cache

The lifetime of this kind of cache is entire workflow. When a particular table is being used in many sessions across the workflow, the table can be made as persistent cache in the lookup table properties. It will be improving the performance considerably.