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
Explain the pipeline partition with real time example?
Where are the source flat files kept before running the session?
What is meant by LDAP users?
What are the databases that informatica can connect to windows?
What is a stored procedure transformation?
Which development components of informatica have the highest usage?
What are the new features of informatica 9.x developer?
Global and Local shortcuts. Advantages.
What is the difference between informatics 7x and 8x and what is latest version?
can anyone explain me about retail domain project in informatica?
What is informatica? Why do we need it?
What do you mean by worklet?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Under what condition selecting sorted input in aggregator may fail the session?
Differentiate between a repository server and a powerhouse?