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
4610 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 pmrep command?

0 Answers

give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.

0 Answers HCL,

What are materialized views & where do we use them?

0 Answers

what is data modeling?

0 Answers

without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers

In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers

Explain the use lookup tables and Aggregate tables?

0 Answers

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

0 Answers

Explain about enterprise scalability and roi of data integration suite?

0 Answers

what is session partitioning?

0 Answers

What are the types of Data Warehouse applications?

0 Answers

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

0 Answers

For more ETL Interview Questions Click Here