What Are The Different Types Of Data Warehousing?

Question

Accepted Answer

There are three types of data warehousing: Enterprise Data Warehouse, Operational Data Store, and Data Mart.

Enterprise Data Warehouse (EDW) is a centralized repository that stores data from various sources and provides a comprehensive view of the organization's data.
Operational Data Store (ODS) is a database that stores real-time or near real-time data from operational systems and serves as a staging area for data integration.
Data Mart is a subset of a data warehouse that focuses on a specific department or business function, providing tailored data for analysis and reporting.
Example: A retail company may have an EDW to store data from sales, inventory, and customer systems, an ODS to capture real-time sales data, and data marts for sales, marketing, and finance departments.

Accepted Answer

Following are the different types of Datawarehousing:

Enterprise Datawarehousing.
Operational Data Store.
Data Mart.

Top Rubicon Exim Warehouse Incharge interview questions & answers