Interested to Buy Any Domain ? << Click Here >> for more details...
What is the advantage of persistent cache? When it should be used.
- 1 Answers
- 6405 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Is it possible to define a single node as a Gateway node as well as worker node?
what are the settiings that u use to cofigure the joiner transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is data merging, data cleansing and sampling?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What is the sql query overwrite in source qualifier in informatica
What are Dimensions and various types of Dimensions?
How to create a non-reusable instance of reusable transformations?
what is the gap analysis?
Examples of Fatal & Non-Fatal error?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
Teradata 
