What is the difference between Data Warehousing and Data Marts? - ProProfs Discuss
Topics-
Products +
     

What is the difference between Data Warehousing and Data Marts?

Asked by T. Lopez, Last updated: Aug 28, 2019

+ AnswerRequest Answer
...

2 Answers

C. Block

Find happiness in writing new things.

C. BlockEnglish Professor, M.A, Ph.D, Buffalo
English Professor, M.A, Ph.D, Buffalo

Answered on Aug 28, 2019

Knowing the difference between data warehousing and data marts can be very confusing at times, especially when you see some people using both interchangeably. Both are referring to the storehouse of data. However, they differ in terms of the type of data that they are meant to house. Data warehousing is a broad central storehouse for all the historical data of a particular organization. Different data belonging to different units and departments of a company are grouped and stored in the data warehousing.

Knowing the difference between data warehousing and data marts can be very confusing at times,
Having a data warehousing for a company will help to make a smooth decision on some matters. Data warehousing is mostly used for bigger organizations and companies. Datamart, on the other hand, is like a subset of data warehousing. It houses data belonging to a specific department in a company. This means every unit, department in an organization or company has its own data mart where necessary data pertaining to the operation of the department is kept.

 Reply

O. Bickis

Get immense pleasure in traveling and writing about visiting places.

O. BickisCorporate employee, MBA, Stockton
Corporate employee, MBA, Stockton

Answered on Jun 13, 2019

A data warehouse is known to have a lot of depth. The data that will be placed in the warehouse is usually extracted from a lot of other units. The information is generally checked first before it will be cleansed and finally included in the data warehouse system. Some people may assume that the data mart is the same as this, but there are some differences between the two.

A data warehouse is known to have a lot of depth. The data that will be placed in the warehouse is
The data mart is part of the data warehouse. It acts as the access layer, which means that this is very helpful in getting the data from the users effectively. Take note that the data that it will get will be specific towards a particular line or team.

 Reply

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.