Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
BiPM Practice Tool Listing Page
Data Mart + Fact Table Grain Matrix
This is matrix is used in dimensional modeling to map data marts against the fact table grain for the data mart. Each Data Mart has a fact table grain. A fact table grain essentially states, the Type of data and the Level of detail of data to be captured in the data mart.
 
This page of 'BiPM Practice Tool' is linked to:  Data Warehousing, Data Analysis/OLAP,

When is Data Mart + Fact Table Grain Matrix used?

Please refer to Marts + Fact Table Grain matrix in Data Warehouse Dimensional Modeling Process for the context of this template.

This template is used during the dimension modeling phase.

Why is it used?

This matrix lays down the fundamental principle behind a data mart, that is- to establish the granularity of data in Data Mart.
   Access more details on this page   
Download Attachment

DE- Data Mart + Fact Table Grain.xls  
Quick Feedback- Was this information helpful ?
Relevant Links to this page
TOPIC - Data Mart Fact Table Grain Matrix in Data Warehouse Dimensional Model → Practice Tools → Data Mart + Fact Table Grain Matrix → 
 
Back
Featured Pages
Metadata Architecture Design
Data Warehouse Implementation Deployment
There is never true-blue DW
BI Organizational Impact success assessment

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Domain and Data Related Services
Implementing Conformed Dimensions
Store granular data in data warehouse
Data Mart + Fact Table Grain Matrix
About Us |  Contact Us |  Privacy Policy |  Terms and Conditions |  Copyright |  Disclaimer |  Site Map
  Executionmih.com © 2010 All rights reserved | Owned by Sagacious Management Solutions | Powered by : Giga Soft Systems Pvt. Ltd