What is the advantage of persistent cache? When it should be used.
Answer / 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 |
Differentiate between a repository server and a powerhouse?
Mention a few design and development best practices for informatica?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Define the various join types of joiner transformation?
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
how to identify new and old values in source qualifier or any other transformations using informatica
What is the Rank index port in Rank transformation?
In a concurrent batch if a session fails, can you start again from that session
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
What are the new features of Power Center 5.0?