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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How will the document be delivered to me?

803


Define Pmrep command?

811


What is option by which we can run all the sessions in a batch simultaneously?

856


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5971


What is repository manager?

740


Clarify the aggregator change?

761


Enlist few areas or real-time situations where informatica is required.

804


how to create user defined function (udf) in informatica

1009


What is the scenario which compels informatica server to reject files?

796


How does the aggregator transformation handle null values?

906


In which transformation you cannot drag ports into it?

1032


What are active transformations.

1396


What does reusable transformation mean?

849


What is a difference between complete, stop and abort?

830


What is a code page?

898