1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the advantage of persistent cache? When it should be used.

Question Posted / ram


What is the advantage of persistent cache? When it should be used...

Answer / ramu

persistent cache is used when u r mapping contains multiple dimensions table, which is used in several times. if you use persistence cache all the index files and data files are stored in memory. when the integration serviece second time calls the same lookup table it wioll fetch the data from the memory cache files instead of re-creating the index and data cache files. we can use the same cache by using one name prefix of the lookup properties.
to use use persistence cache we can divide them in to two types.
1) names persistence cache
2) un named persistence cache.

1) named persistence cache: we can use the same persistence cache between several mappings.
2)un named persistence cache we can use the same cache with in the mapping only.

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Informatica Interview Questions

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

what is parallel querying and what r hints.

1 Answers  

Differences between connected and unconnected lookup?

0 Answers  

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,




Explain incremental aggregation in informatica

0 Answers   Informatica,

why we use stored procedure transformation?

4 Answers   IBM,

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

What does refresh system mean, and what are its distinctive choice?

0 Answers  

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  

Can you start a batches with in a batch?

1 Answers  

What are the phases in SDLC?

3 Answers  

For more Informatica Interview Questions Click Here
Categories