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 Operational Database and Data Warehouse?
• What is the difference between Data Mining and Data Warehouse?
• Difference between a data warehouse database and an OLTP database?
• Difference between data type and data structure
• Difference Between Data Mining and Data Warehousing
• Difference between Data mining and Data Science?
• Difference between Data Mining and Big Data?
• Difference Between Data and Metadata
• Difference Between Data and Information
• What is Data Warehouse?
• Difference between fundamental data types and derived data types
• Difference between Data lake and Datawarehouse
• Difference Between Abstraction and Data Hiding
• Difference Between Data Hiding and Encapsulation