In this post, we will understand the difference between data warehouse and data mart.
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.
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.