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 |
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What is the Difference between PowerPlay transformer and power play reports?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
How will you convert rows into columns or columns into rows
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
in oracle write query yourname+1 from dual
what is pre and post sql and what is diff between source presql and target pre sql
What is native users?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,