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 anyone suggest best free Talend data integration training online
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Describe data concatenation?
What is target designer and target load order?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is informatica?
What is source qualifier transformation in informatica?
What do you mean by channel change?
What are the types of caches in lookup? Explain them.
What is rank transform?
Why update strategy and union transformations are active?
Explain scd type 3 through mapping.
Whats the difference between informatica powercenter server, repositoryserver and repository?
How do we call shell scripts from informatica?
What is transformation?