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 can you generate reports in informatica?
Define sessions in informatica etl?
Separate from an archive server and a powerhouse?
What is meant by pre and post session shell command?
What does role playing dimension mean?
what is the Default Source Option For Update Strategy Transformation?
What do you mean by blocking transformation?
list out all the transformations which use cache?
what are 3 tech challenges/ common issues you face?
Why do you use Mapping Parameter and mapping variable?
What is aggregator transformation in informatica?
What do think which one is the better joiner or look up?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many input parameters can exist in an unconnected lookup?
differences between service based and product based?