What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Data Mart as PDF --


 

Data Mart

It is a subset of data warehouse and it supports a particular region, business unit like Sales, Marketing, HR, Finance. DW’s and DM’s are built on dimensional data modeling where fact tables are connected with dimension tables.

In an independent data mart, data can be collected directly from sources

In an dependent data mart, data can  be derived from an enterprise data warehouse.

A data mart can contain operational data, summarized data, spatial data, or meta-data.

 

reference: http://www.executionmih.com/data-warehouse/definition-concept.php

Data mart is a limited set of dimensions and measures used for specific business theme. They are populated out of the Data-Warehouse Data Sets.

Typically an organization’s business intelligence agenda starts with few data marts, before maturing to a full-blown data warehouse. However, most of the design & development concept apply equally to a Data-mart.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

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


*