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
What is union transformation?
Explain Dataware house architecture .how data flow from intial to end?
expain about the tune parameters?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
explain one complex mapping with logic? sales project?
Performance tuning in UNIX for informatica mappings?
What is the function of look up transformation?
How can we store previous session logs?
On which transformations you created partitions in your project?
Explain the mapping variable usage example in informatica
What is the difference between a repository server and a powerhouse?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a router transformation?
Can u generate reports in Informatica?
Make a note of the quantity vaults made in informatica?