Interested to Buy Any Domain ? << Click Here >> for more details...
When will u go for Dynamic Cache and Persistent Cache? Pls
explain with an example?
- 2 Answers
- 9269 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
What is a code page?
Define sessions in informatica etl?
What is resilience time?
Enlist the differences between database and data warehouse.
Explain the features of connected and unconnected lookup.
Differentiate between source qualifier and filter transformation?
Can you use flat files in Mapplets.
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
lookup transformation with screenshots
What is InformaticaPowerCenter?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is joiner change?
What is olap (on-line analytical processing?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the differences between a connected lookup and unconnected lookup?
