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



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

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,


Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  


What is lookup change?

0 Answers  


what are types of dimentions?

3 Answers  


I have a flat file, want to reverse the contents of the flat file

0 Answers   Informatica,


What are the data movement modes in informatcia?

3 Answers  


I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,


111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


Clarify the utilization of aggregator cache record?

0 Answers  


What are the connected or unconnected transforamations?

2 Answers  


what is semi-additive fact?where did u used?

2 Answers  


I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


Categories