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

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,


hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,


If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,


In any project how many mappings they will use(minimum)?

1 Answers  


What is difference between stored procedure transformation and external procedure transformation?

2 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


Differentiate between source qualifier and filter transformation?

0 Answers  


What is Target Update Override? What is the Use ?

8 Answers   Patni,


How many ways are there to create ports?

0 Answers   Informatica,


What is the benefit of session partitioning?

0 Answers  


What is a dimensional model?

0 Answers  


WHat all joins are there in Source Qualifier?

1 Answers  


Categories