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
what is diff b/t sorter t/r and agg have the option sorter property...
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Clarify the utilization of aggregator cache record?
What is persistent lookup cache?
Explain joiner transformation in informatica
How would you copy the content of one repository to another repository?
What is incremental aggregation?
Enlist the advantages of informatica.
How to generate sequence numbers?
What is a joiner transformation?
What is the difference between Active and Passive transformation?
What are the differences between a connected lookup and unconnected lookup?
What are the types of caches in lookup? Explain them.
update strategy transformation in informatica
Differentiate between reusable transformation and mapplet.