What is the advantage of persistent cache? When it should be used.
Answer Posted / 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 |
Post New Answer View All Answers
have u done any performance tuning? how u ll do?
what is degenerated dimension?
update strategy transformation in informatica
What does reusable transformation mean?
How to Create a folder using pmrep command?
How will the document be delivered to me?
what is the size of your data warehousing?
Can anyone tell me the new features in Informatica 9 Version?
can we override a native sql query within informatica? How do we do it?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the different types of olap? Give an example?
What is the sql query overwrite in source qualifier in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the components of workflow manager?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM