When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?

Answers were Sorted based on User's Feedback



When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?..

Answer / harish konda

Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.

If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.

The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".

So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.

Is This Answer Correct ?    4 Yes 0 No

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?..

Answer / rayudu

If the lookup cache doesnt change between mutiple runs and
if we know that the lookup data doesnt change then we will
go for Persistant cache.


If the loopup cache changes between multiple session runs
and to keep the target table and lookup cache synchronized
we will use dynamic lookup cache .

regards,
rayudu.

Is This Answer Correct ?    7 Yes 4 No

Post New Answer

More Informatica Interview Questions

How many ways you create ports?

1 Answers  


why we use datawarehouse

0 Answers   HCL,


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  


What is informatica? Why do we need it?

0 Answers  


What are the various types of transformation?

0 Answers  


Describe expression transformation?

0 Answers  


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


in which situations do u go for snowflake schema ?

2 Answers   TCS,


Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


what is mapping override?

2 Answers   Cap Gemini,


Categories