Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is the advantage of persistent cache? when it should be
used?

Answers were Sorted based on User's Feedback



what is the advantage of persistent cache? when it should be used?..

Answer / san

when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,

Is This Answer Correct ?    1 Yes 0 No

what is the advantage of persistent cache? when it should be used?..

Answer / kvikas2056

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

Post New Answer

More ETL Interview Questions

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  


In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  


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

0 Answers  


what is pmrep command?

1 Answers  


where is the cache (lookup, index) created and how can you see it.

0 Answers  


what are the different forms of normalization?

2 Answers  


Eliminating of duplicate records without using dynamic lookups

3 Answers  


What are the key benefits of ETL Testing?

0 Answers  


What do you understand by active and passive transformations?

0 Answers  


what are the data modeling tools you have used?(polaris)

0 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


State the differences between shortcut and reusable transformation

0 Answers  


Categories