GeekInterview.com
Series: Subject: Topic:
Question: 9 of 75

Cache Files

What are the T/Rs which create cache files?
Asked by: YugandharS | Member Since Jun-2010 | Asked on: Jul 27th, 2010

View all questions by YugandharS   View all answers by YugandharS

Showing Answers 1 - 3 of 3 Answers
jyothi_rayala

Answered On : Feb 27th, 2011

View all answers by jyothi_rayala

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.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.