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
How will the document be delivered to me?
Define Pmrep command?
What is option by which we can run all the sessions in a batch simultaneously?
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?
What is repository manager?
Clarify the aggregator change?
Enlist few areas or real-time situations where informatica is required.
how to create user defined function (udf) in informatica
What is the scenario which compels informatica server to reject files?
How does the aggregator transformation handle null values?
In which transformation you cannot drag ports into it?
What are active transformations.
What does reusable transformation mean?
What is a difference between complete, stop and abort?
What is a code page?