What is the advantage of persistent cache? When it should be used.
Answer Posted / ramu
persistent cache is used when u r mapping contains multiple dimensions table, which is used in several times. if you use persistence cache all the index files and data files are stored in memory. when the integration serviece second time calls the same lookup table it wioll fetch the data from the memory cache files instead of re-creating the index and data cache files. we can use the same cache by using one name prefix of the lookup properties.
to use use persistence cache we can divide them in to two types.
1) names persistence cache
2) un named persistence cache.
1) named persistence cache: we can use the same persistence cache between several mappings.
2)un named persistence cache we can use the same cache with in the mapping only.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the reusable transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Different sorts of metadata that stores in the storage facility?
Please let me know how to make encryption and decryption with example?
How to handle decimal places while importing a flatfile into informatica?
Clarify the utilization of aggregator cache record?
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
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
pmscmd startworkflow -sv
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Quickly characterize reusable change?
Describe the impact of several join conditions and join order in a joiner transformation?
What will be the approach?
can you please explain me pre session and post session options?
How will the document be delivered to me?