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 |
How u use pdf file in informatica source?
Howmany ways yoU can update a relational source defintion and what are they?
explain abt joiner t/r?
how to get the first row without using rank t/r?
What is a design?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
During the running session, output files are created by informatica server. Enlist few of them.
If we set dd_insert in mapping and Delete in session properties what will happen.?
How the Informatica Server reads perameter file?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?