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 |
How to reduce warnings?
Explain what are the vaious etl tools in the market?
What is an OLTP (Online Transaction Processing) System?
Explain what is cost benefit analysis (cba)?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Disply the dname wise maximum salary
Explain what is the extension of file to save template?
What is a data profile?
How can we determine what records to extract?
Explain the differences between normalizer and normalizer transformation?
What is cost benefit analysis (cba)?
What is difference between Mapplet and reusable transformation?