What is the difference between dependent data warehouse and independent data warehouse?



What is the difference between dependent data warehouse and independent data warehouse?..

Answer / Nagendra Kumar Verma

A Dependent Data Warehouse relies on the source system for its data, as it extracts and processes data from operational databases in real-time or near real-time. An Independent Data Warehouse, on the other hand, has a separate and self-contained database that is periodically updated with ETL (Extract, Transform, Load) processes. It can store historical data for extended periods to support long-term analysis.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

How to reduce warnings?

1 Answers  


Explain what are the vaious etl tools in the market?

1 Answers  


What is an OLTP (Online Transaction Processing) System?

4 Answers  


Explain what is cost benefit analysis (cba)?

1 Answers  


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1 Answers   iGate,


Disply the dname wise maximum salary

9 Answers   Principal Finance,


Explain what is the extension of file to save template?

1 Answers  


What is a data profile?

1 Answers  


How can we determine what records to extract?

1 Answers  


Explain the differences between normalizer and normalizer transformation?

1 Answers  


What is cost benefit analysis (cba)?

1 Answers  


What is difference between Mapplet and reusable transformation?

3 Answers   UST,


Categories