COMPARE DATA MART AND DATA WAREHOUSE

DATA MART VS DATA WAREHOUSE
DATA MART VS DATA WAREHOUSE

INTRODUCTION

In this article, I will COMPARE DATA MART AND DATA WAREHOUSE

What is data mart?

DATA MART can be defined as the subset of a data warehouse of an organization that is limited to a specific business unit or group of users. 

What is a Data Warehouse?

A data warehouse is a repository of information collected from multiple sources, stored under a unified schema, and usually residing at a single site

Comparison of data mart and data warehouse

Parameter DATA WAREHOUSE DATA MART
Subjects Holds data from multiple subject point of view Holds data from the specific subject (Mostly one subject area)  E.g. marks, sales, etc
Data Source Has concentrated data from multiple sources and multiple subject areas.  It has a specific form of data and a single data source.
Data Perspective Holds detailed information and data  Holds summarized data only
Dimensional Models Contains all data no dimensional models are applied It contains summarized data available after applying the dimensional model.
Characteristics Flexible Data Orientation Durable Restrictive Project Orientation Tactical
Scope Application Neutral Centralized Specific Application Department specific

GOOD JOB DONE BY THIS WEBSITE THAT HAS GIVEN THE CALCULATOR FOR FIVE-NUMBER SUMMARY.

IF YOU LIKE TO DO SOME PROJECTS VISIT HERE FOR SMALL AND RELIABLE PROJECT.

Leave A Reply

Your email address will not be published. Required fields are marked *