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


Please Help Members By Posting Answers For Below Questions

How to go to the older version for a mapping?

606


What is workflow? What are the components of the workflow manager?

646


What are the guidelines to be followed while using union transformation?

643


What is the difference between informatics 7x and 8x and what is latest version?

549


How you know when to use a static cache and dynamic cache in lookup transformation?

1345






What is the sql query overwrite in source qualifier in informatica

621


what is unit testing?tell me proceedure

1786


Whats there in global repository

1272


What are the different ways to implement parallel processing in informatica?

867


How do we call shell scripts from informatica?

602


Explain the different lookup methods used in informatica?

593


Describe the impact of several join conditions and join order in a joiner transformation?

649


Informatica settings are available in which file?

593


What is a passive transformation?

646


What is meant by a domain?

634