what is the advantage of persistent cache? when it should be
used?
Answers were Sorted based on User's Feedback
If you are using multiple look up transformations on same table, at that time you can use persistent named cache.
| Is This Answer Correct ? | 0 Yes | 0 No |
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
In Which Transformation We Can Use Having Clause In Informatica?
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
what is pmrep command?
where is the cache (lookup, index) created and how can you see it.
what are the different forms of normalization?
Eliminating of duplicate records without using dynamic lookups
What are the key benefits of ETL Testing?
What do you understand by active and passive transformations?
what are the data modeling tools you have used?(polaris)
explain the methodology of Data Warehousing?(Polaries)
State the differences between shortcut and reusable transformation