DecisionWorks ConsultingOctober 2010 - DecisionWorks Consulting
  • Home
  • Training
    • Onsite Course Descriptions
    • Public Course Description
    • Public Class Schedule
    • Public Class Pricing and FAQ
  • Consulting
    • DW/BI Strategy Assessments
    • Business Requirements
    • Dimensional Modeling
    • Design Review
    • DW/BI Project Review
  • Resources
    • Books
    • Articles & Design Tips
    • Kimball Techniques
  • About
  • Contact
  • Learn Dimensional Modeling from Kimball Toolkit Experts!

DecisionWorks Consulting

Learn Dimensional Modeling from expert Margy Ross, Ralph Kimball's Toolkit co-author
  • Home
  • Training
    • Onsite Course Descriptions
    • Public Course Description
    • Public Class Schedule
    • Public Class Pricing and FAQ
  • Consulting
    • DW/BI Strategy Assessments
    • Business Requirements
    • Dimensional Modeling
    • Design Review
    • DW/BI Project Review
  • Resources
    • Books
    • Articles & Design Tips
    • Kimball Techniques
  • About
  • Contact

Monthly Archives: October 2010

  • Home /
  • Design Tip #128 Selecting Default Values for Nulls/
  • 2010 /
  • October

Design Tip #128 Selecting Default Values for Nulls

  • Bob Becker
  • October 6, 2010

Design Tip #43 Dealing with Nulls in the Dimensional Model describes two cases where null values should be avoided in a dimensional model; in these situations, we recommend using default values rather than nulls. This Design Tip provides guidance for selecting meaningful, verbose defaults. Handling Null Foreign Keys in Fact Tables The first scenario where […]

Categories

  • Before Diving In
  • Project/Program Planning
  • Requirements Definition
  • Data Architecture
  • Dimensional Modeling Fundamentals
  • Dimensional Modeling Tasks
  • Fact Table Core Concepts
  • Dimension Table Core Concepts
  • Advanced Dimension Patterns & Case Studies
  • ETL and Data Quality
  • Business Intelligence Applications
  • Maintenance and Growth

Archives

  • 2017
    • September
  • 2015
    • October
    • September
    • May
    • March
  • 2014
    • November
    • June
    • May
  • 2013
    • November
    • October
    • June
    • May
    • April
    • February
  • 2012
    • August
    • April
    • March
  • 2011
    • October
    • September
    • June
    • April
  • 2010
    • December
    • October
    • September
    • June
    • May
    • March
    • February
  • 2009
    • November
    • October
    • August
    • May
    • March
  • 2008
    • December
    • September
    • July
    • May
    • January
  • 2007
    • October
    • June
    • March
    • February
  • 2006
    • October
    • September
    • July
    • June
    • April
    • March
  • 2005
    • December
    • November
    • October
    • July
    • May
    • April
    • March
    • February
  • 2004
    • October
    • August
    • June
    • May
    • March
    • January
  • 2003
    • October
    • September
    • August
    • June
    • March
    • February
  • 2002
    • November
    • May
  • 2000
    • October
    • April
    • January

Latest Articles

  • Is Dimensional Modeling Still Relevant?
  • Design Tip #178 Tried and True Concepts for DW-BI Success
  • Design Tip #177 Final Word of the Day: Collaboration
  • Design Tip #174 Does Your Organization Need an Analytic Sandbox?

Education Services

  • Onsite Course Descriptions
  • Public Course Description
  • Public Class Schedule
  • Public Class Pricing and FAQ

Consulting Services

  • DW/BI Strategy
  • DW/BI Requirements
  • Dimensional Modeling
  • Dimensional Model Design Review
  • DW/BI Project Review

Resources

  • Books
  • Articles & Design Tips
  • Kimball Techniques
DecisionWorks Consulting, Inc. All Rights Reserved. Spark Logix Studios
  • About
  • Contact
  • Sitemap
  • Privacy Policy