Difference Between Data Warehouse and Data Mart

In this post, we will understand the difference between data warehouse and data mart.

Data Warehouse

• It is a large repository of data that is collected from different organizations within a corporation.

• It helps make a strategic decision.

• The main objective is to provide an integrated environment and coherent image of the business.

• The designing process is tough.

• It may or may not be used in a dimensional model.

• It can feed dimensional models.

• It includes large areas of the corporation, hence it takes a long time to process it.

Data Mart

• It is a subtype of data warehouse.

• It is designed to meet the requirement of a specific user group.

• It helps make tactical decisions for business.

• It is generally used in the business division at the departmental level.

• The process of designing it is easy.

• It is built by focusing on a dimensional model.

• They are easy to use, and implement.

• They can only handle small amounts of data.

AmitDiwan

Published on 25-Mar-2021 06:12:43

• Related Questions & Answers
• Difference between Data warehouse and Operational database
• Difference between data type and data structure
• Difference Between Data Mining and Data Warehousing
• Difference Between Data and Metadata
• Difference Between Data and Information
• Difference between fundamental data types and derived data types
• Difference between Data Scientist, Data Engineer, Data Analyst.
• Difference between Data lake and Datawarehouse
• Difference Between Abstraction and Data Hiding
• Difference Between Data Hiding and Encapsulation
• Difference between Stack and Queue Data Structures
• Difference Between Descriptive and Predictive Data Mining
• Difference between fundamental data types and derived data types in C++
• Difference between Linear and Non-linear Data Structures
• Difference between Structured, Semi-structured and Unstructured data