Difference between Data Warehouse and Data Mart

Key Difference: Data Warehouse is a big central repository of historical data. This data is assembled from different departments and units of the company. Data Mart can be considered as a subset of data warehouse or simply a data repository which is generally focused on a single functional area. They both primarily vary in their scope and usage area.

Basically, a data warehouse is a collection of data which is isolated from the operational systems. It assists in the decision making of the company. The data is assembled from multiple sources in order to provide accurate and timely information. The data is stored from a historic perspective.

The data in the warehouse is information which has been extracted efficiently from multiple functional units. It is checked, cleaned and finally integrated to be a part of the warehouse. Data warehouses are controlled and implemented by a central organizational unit.

A data mart is an important subset of a data warehouse. It is specifically subject oriented, and it is designed to meet the needs of a specific group of users. Data marts can be individually designed for departments like Sales, Finance, etc.

Data marts are generally controlled by a single department of an organization. The data for these data marts is assembled only from a few sources. Thus, data mart and data warehouse mainly differ in their scope and data sources. Data marts are generally less than 100 GB in size, whereas the size of a data warehouse is typically larger than 100 GB. Due to the difference in scope, it is comparatively easy to design and use data marts. However, using a data warehouse can be difficult and complex at the same time.

Comparison between Data Warehouse and Data Mart:


Data Warehouse

Data Mart


Removing informational processing load from transaction-oriented databases.

Data Mart can be considered as a subset of data warehouse. It is generally focused on a single functional area.


Multiple subject areas

Specific subject area


Central organization unit

Generally, single department



Line of Business

Data Sources


Few selected


100 GB-TB+

< 100 GB


Comparatively difficult



  • It is accessible across the enterprise
  • Contains historical and current data
  • Can be considered as a "single version" of the truth about enterprise activities.
  • Removes informational processing load from transaction-oriented databases


  • Incremental development
  • Easy understanding of data
  • Simple data design
  • Easy Manipulation of data
  • Better Reporting performance due to smaller queries


Implementation time

Months to years






Image Courtesy: plotting-success.softwareadvice.com, tutorialspoint.com

Most Searched in Electronics Most Searched in Environment
Most Searched in Society and Culture Most Searched in Pregnancy and Parenting
 Types of Pencils
Point vs Line vs Plane
Curling vs Field Hockey

Add new comment

Plain text

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.