Diffrence between static and dynamic cache

Answers were Sorted based on User's Feedback



Diffrence between static and dynamic cache..

Answer / siva prasad

Static cache: Is readonly cache. We cannot insert or update
the records dynamically.

Dynamic Cache: It will refresh the changed data and
allocate a seperate buffer for that.Each time it will
identify the changed data rather than capture entire
data.we can insert or update the records dynamically.

Is This Answer Correct ?    5 Yes 0 No

Diffrence between static and dynamic cache..

Answer / sushma

If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  


A session S_MAP1 is in Repository A. While running the session error message has displayed

1 Answers  


Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,


What is difference macros and prompts?

2 Answers  


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  


I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,


What is the difference between Power Centre and Power Mart?

5 Answers   TCS,


what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,


what is inline view?

1 Answers   IBM,


What will be the approach?

0 Answers  


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


What are the tasks that source qualifier perform?

0 Answers   Informatica,


Categories