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 |
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What does command task mean?
What is xml source qualifier transformation in informatica?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
Explain joiner transformation in informatica
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
what is lookup chache?
What are the differences between source qualifier and joiner transformation?
What is CDC? How to implement CDC?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
how can u approach u r client
Under which circumstances, informatica server creates reject files?