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...

  1. Categories >> Software >> Data Warehouse >> ETL
  2. Suggest New Category

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

Question Posted / jakki

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

what is SMP AND MPP?

8 Answers  

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

What are snapshots?

0 Answers  

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers   Accenture,

What are snapshots? What are materialized views & where do we use them? What is a materialized view log?

0 Answers  

What are the steps involved in etl process?

0 Answers  

What is virtual Data Warehousing?

0 Answers  

Explain me ETL project architecture in Detail?

0 Answers   Infosys,

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

0 Answers   Tech Mahindra,

what are the different Reporting and ETL tools available in the market?

3 Answers  

What are the ETL Testing Operations?

0 Answers  

what are the session parameters? How do u set them?

0 Answers  

For more ETL Interview Questions Click Here
Categories