A major difference between two-level and three-level data warehouses is the creation of an enterprise data warehouse.

Question

Quizplus · Accepted Answer

The creation of an enterprise data warehouse is a major difference between two-level and three-level data warehouses. In a two-level data warehouse, the data is typically organized into two layers: the operational data store (ODS) and the data warehouse. However, in a three-level data warehouse, a third layer called the enterprise data warehouse is added to enable integration of data from multiple sources and support enterprise-wide reporting and analysis.

A Major Difference Between Two-Level and Three-Level Data Warehouses Is