When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 8846 Views
- TCS, I also Faced
- E-Mail Answers
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
Write the different tools in the workflow manager?
When do you use sql override in a lookup transformation?
What is the advantage of informatica?
What is Index Caches size?
How is union transformation utilized?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
Is there any target staging area in informatica not staging area
How do you take back up of repository?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the popular informatica products?
Explain about cumulative Sum or moving sum?
What are active transformations.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
