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 |
Why update strategy and union transformations are active? Explain with examples.
what are the differences between powercenter 8.1 and powercenter 8.5?
what is procedure to use mapping variable in source qualifier transformation? with example
What is a repository manager?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
What is the functionality of update strategy?
Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Using Connected or unconnected lookup for performance wise which one is preferable?.
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
What do you mean by blocking transformation?