Cache Files

What are the T/Rs which create cache files?

Questions by YugandharS   answers by YugandharS

Showing Answers 1 - 10 of 10 Answers

jyothi_rayala

  • Feb 27th, 2011
 

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.

  Was this answer useful?  Yes

shiva

  • Jul 22nd, 2011
 

Actually the answer is partially related to the Question.......

t/rs like Joiner, Lookup, Aggregator,Rank Transformations uses the Caches.....

  Was this answer useful?  Yes

deepthi

  • Aug 20th, 2011
 

aggregator
joiner
lookup
rank
sorter

  Was this answer useful?  Yes

sowjanya

  • Oct 21st, 2014
 

sorter,lookup,joiner,rank,aggregator

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions