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

working of line item dimension......pls,tell overall flow

1 Answers  


What is etl process?

0 Answers  


how do u extract data from different data sources explain with an example?

0 Answers  


what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  


hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,






Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


can cubes contain measures ?

0 Answers  


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

2 Answers  


How many steps etl contains explain with example?

0 Answers  


where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


What is Relational Integrity?

1 Answers  


Categories