When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
Answer Posted / harish konda
Dynamic cache is used to update/insert the records into the
cache during the session run. From there we can
update/target table with the NewLookupRow values returned by
lookup.
If you want to use the same lookup cache in other mappings
also then we will go for Persistent Cache.
The difference is for eg, in the first mapping when we use
dynamic cache, when the session ends, the cache gets deleted
automatically. So to use this cache in other mappings also
check give one option "Persistent Cache".
So when we use this option, the cache in the memory gets
Saved even after session ends. From there we can use that in
other mappings.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Why is sorter an active transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what are the Methods For Creating Reusable Transformations?
What is domain in terms of informatica?
what is index?how it can work in informatica
How to start a workflow using pmcmd command?
If informatica has its scheduler why using third party scheduler?
Tell me about MD5 functions in informatica
How are the sources and targets definitions imported in informatica designer?
what is the complex transformation you used in informatica
What are the designer tools for creating transformations?
can u give example for factless fact table
What is the difference between informatics 7x and 8x and what is latest version?
How many ways are there to do 'remove duplicate records in informatica'?
How you can differentiate between connected lookup and unconnected lookup?