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
How to go to the older version for a mapping?
What is workflow? What are the components of the workflow manager?
What are the guidelines to be followed while using union transformation?
What is the difference between informatics 7x and 8x and what is latest version?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the sql query overwrite in source qualifier in informatica
what is unit testing?tell me proceedure
Whats there in global repository
What are the different ways to implement parallel processing in informatica?
How do we call shell scripts from informatica?
Explain the different lookup methods used in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
Informatica settings are available in which file?
What is a passive transformation?
What is meant by a domain?