DecisionWorks ConsultingFebruary 2013 - 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: February 2013

  • Home /
  • Design Tip #152 Slowly Changing Dimension Types 0, 4, 5, 6 and 7/
  • 2013 /
  • February

Design Tip #152 Slowly Changing Dimension Types 0, 4, 5, 6 and 7

  • Margy Ross
  • February 5, 2013

Ralph introduced the concept of slowly changing dimension (SCD) attributes in 1996. Dimensional modelers, in conjunction with the business’s data governance representatives, must specify the data warehouse’s response to operational attribute value changes. Most Kimball readers are familiar with the core SCD approaches: type 1 (overwrite), type 2 (add a row), and type 3 (add […]

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