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

when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.

Question Posted / vasu


when do we use static cache and when do we use dynamic cache in lookup transformation? with exampl..

Answer / swapna

static cache is used when the records in the source does not update more frequently.

dynamic cache is used when the records in the source frequently updates.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is aggregate awareness?

1 Answers  

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

WHat all joins are there in Source Qualifier?

1 Answers  

What is the difference between STOP and ABORT options in Workflow Monitor?

0 Answers  




what is session override?

2 Answers   Cap Gemini,

Which kind of index is preferred in DWH?

2 Answers  

why union is active transformation?

4 Answers   IBM,

explain about lookup t/r?

1 Answers   IBM,

How to load a Dimension ? and how to load a fact table?

0 Answers  

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories