Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


3 Answers   Wipro,

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

What is the maplet?

0 Answers   Informatica,

Which is better performance wise database or file?How?

2 Answers   TCS,

What is the need of building a data warehouse?

2 Answers  

Write the different tools in the workflow manager?

0 Answers  


4 Answers   TCS,

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

What is mapplet in informatica?

0 Answers  

how many types transformations supported by sortedinput?

4 Answers