When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 8597 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
How to generate sequence numbers using expression transformation?
What is Data Caches size?
What is a joiner transformation?
What is target load order?
Explain scd type 3 through mapping.
can anyone suggest best free Talend data integration training online
What are the types of presistent cache in look up tr.
If informatica has its scheduler why using third party scheduler?
Where do we use mapping variables in informatica?
Enlist the tasks for which source qualifier transformation is used.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Design a mapping to load a target table with the following values from the above source?
What is dynamic cache?
Explain the difference between mapping parameter and mapping variable?
what is Active lock explain
