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

what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers

tell me few points when u become TL

0 Answers Infosys,

what is a worklet?

0 Answers

What are materialized views & where do we use them?

0 Answers

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

0 Answers

what happens if the info.server doesn't find the session parameter in the parameter file?

1 Answers

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

0 Answers L&T,

When do we go for the tools in the market?

0 Answers

Eliminating of duplicate records without using dynamic lookups

4 Answers IBM,

What is partitioning? Explain about round-robin, hash partitioning.

0 Answers

Mention few test cases and explain them?

0 Answers

explain the methodology of Data Warehousing?(Polaries)

0 Answers

For more ETL Interview Questions Click Here