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

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

Question Posted / jakki

2 Answers
4781 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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 reporting tools and difference between them?

0 Answers

Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers

what is meant by drill through?(Mascot)

1 Answers

How to delete data which is not in source table?

0 Answers IBM, Saama Tech, Wipro,

Eliminating of duplicate records without using dynamic lookups

1 Answers

What is a lookup table in etl?

0 Answers

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

0 Answers

what is the difference steps for data modeling?