Building Making It Happen
Building Making It Happen
  Sign-in         Register
    
Principles and Rules Listing Page
Dimension Attributes as NULL
You should generally not leave dimension attributes as NULL.
 
This page of 'Principles and Rules' is linked to:  Data Warehousing, Data Analysis/OLAP, BI platform Tools Evaluation, BI business intelligence end-to-end view,

This with with reference to other field tips (Handling facts as Nulls and Handling NULL fact foreign keys). In case you have a situation where the dimension attributes as NULL, you should not leave them like that. NULL creates confusion for the users as they appear in reporting and some of the OLAP systems have different ways to handle these NULLs. The best way is to provide a user-friendly string or description. For example "Not-available", "Not-Applicable", "Not-provided".

   Access more details on this page   
Quick Feedback- Was this information helpful ?
Relevant Links to this page
Principles & Rules → Data Warehouse application is not limited to Analytics → Principles & Rules → Store as much detailed and granular data in data warehouse as possible → Principles & Rules → Data Normalization is not the best approach in Dimensional modeling → Principles & Rules → Keep the same names and definitions for all data elements → Principles & Rules → You cannot have a super-flexible Data warehouse → Principles & Rules → Dimensional models can be extensible and scalable → Principles & Rules → Data Marts should be ideally based upon a business process and not on a department. → Principles & Rules → Business Intelligence competency groups should be well-linked with business → Practice Techniques → Aggregation Queries on slowly changing Dimensions → Practice Techniques → Documenting your data-integration system → Principles & Rules → For a Data Warehouse/Data-Mart solution, analyze well, but be decisive → Principles & Rules → Maintain a trail of the key dimensional elements from source system to loaded → Principles & Rules → Conformed dimensions are must for cross-drilling → Practice Techniques → Checksum Approach for identifying the changed records from source systems → Principles & Rules → Dimensional model has to be aligned to the Entity-Relationship → Principles & Rules → Always Use Conformed Dimensions → Principles & Rules → You may not be a able to have a perfect ETL → Practice Techniques → Handling Sparse Dimensional tables → Principles & Rules → Do not separate the parent and child line item data → Practice Techniques → Managing time-stamps across multiple time-zones → Practice Techniques → Recording events in multiple currencies → Practice Techniques → Handle different units of measure in the same fact table → Principles & Rules → Handling of Null foreign Keys in fact tables → Principles & Rules → Dimension Attributes as NULL → Principles & Rules → Don't rely too much on Meta Data Tools to enforce Business Intelligence → Principles & Rules → Don't wait for universal models for Data Marting → 
 
Back
Featured Pages
MDM Tools- Entity Management
Data Warehouse Benefits Usage
Metadata Extraction, Transformation and Loading
Data Min-Max Analysis

Make 'Executable' Strategy
Maximize Results
Maximize People
Manage Execution

Featured Pages
Data Monitoring Checklist
Data-Warehouse Deploy-checklist
Data Warehouse Testing Categories
Three Tier Data Warehouse
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