Cache files are mainly used in Lookup transformations in Informatica
2 types
Static cache , Dynamic cache.
Both are used by connected lookup
Unconnected lookup uses only static cache.
If Lookup SQL Override is used it uses Index cache and Data Cache
Index cache - Stores key columns ( i.e on which index present)
Data Cache - Stores output values.
These 2 files sufficient memory allocation is important aspect in case of lookup optimization. If the memory allocation is Auto, make sure that Maximum Memory Allowed For Auto Memory Attributes , Maximum Percentage of Total Memory Allowed For Auto Memory Attributes is defined properly.
Login to rate this answer.
shiva
Answered On : Jul 22nd, 2011
Actually the answer is partially related to the Question.......
t/rs like Joiner, Lookup, Aggregator,Rank Transformations uses the Caches.....
Login to rate this answer.
deepthi
Answered On : Aug 20th, 2011
aggregator
joiner
lookup
rank
sorter
Login to rate this answer.