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 can you generate reports in informatica?

668


Define sessions in informatica etl?

702


Separate from an archive server and a powerhouse?

579


What is meant by pre and post session shell command?

737


What does role playing dimension mean?

715






what is the Default Source Option For Update Strategy Transformation?

856


What do you mean by blocking transformation?

675


list out all the transformations which use cache?

772


what are 3 tech challenges/ common issues you face?

1981


Why do you use Mapping Parameter and mapping variable?

1377


What is aggregator transformation in informatica?

629


What do think which one is the better joiner or look up?

849


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

625


How many input parameters can exist in an unconnected lookup?

1150


differences between service based and product based?

1655