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

how to load the data to fact table?

0 Answers  

What is a mapping, session, worklet, workflow, mapplet?

0 Answers  

what is pmrep command?

0 Answers  

when will use SQL override in a lookup transformation?

0 Answers  

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

what are the different forms of normalization?

2 Answers  

What is cube grouping?

0 Answers  

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

0 Answers  

What are the etl testing operations includes?

0 Answers  

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  

Can u access a repository created in previous version of Informatica?

1 Answers  

What is grain of fact?

0 Answers  

For more ETL Interview Questions Click Here
Categories