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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the components of Informatica? And what is the purpose of each?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is an active transformation?
Differentiate between joiner and lookup transformation?
How to update a particular record in target with out running whole workflow?
Explain sessions and how many types of sessions are there?
What are the different clients of powercenter?
Different sorts of metadata that stores in the storage facility?
How can you generate reports in informatica?
What is a repository manager?
How to elaborate powercenter integration service?
What is the status code in stored procedure transformation?
What is informatica metadata and where is it stored?
Write the unconnected lookup syntax?