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

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  


what is the difference between cardinality and Nullability?

0 Answers  


what is HISTOGRAM? how to generate statistics?

1 Answers  


what is dynamic insert?

0 Answers  


please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

0 Answers  






What are cubes and olap cubes?

0 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 a materialized view log?

0 Answers  


What are the ETL Testing Operations?

0 Answers  


Explain about enterprise scalability and roi of data integration suite?

0 Answers  


what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers  


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

0 Answers  


Categories