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

what is diff b/t sorter t/r and agg have the option sorter property...

1737


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?

546


Clarify the utilization of aggregator cache record?

575


What is persistent lookup cache?

598


Explain joiner transformation in informatica

664






How would you copy the content of one repository to another repository?

549


What is incremental aggregation?

570


Enlist the advantages of informatica.

626


How to generate sequence numbers?

616


What is a joiner transformation?

549


What is the difference between Active and Passive transformation?

631


What are the differences between a connected lookup and unconnected lookup?

643


What are the types of caches in lookup? Explain them.

547


update strategy transformation in informatica

636


Differentiate between reusable transformation and mapplet.

568