DecisionWorks ConsultingOctober 2000 - 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 2000

  • Home /
  • Design Tip #15: Combining SCD Techniques/
  • 2000 /
  • October

Design Tip #15: Combining SCD Techniques

  • Margy Ross
  • October 29, 2000

The acronym, SCD, is a keyword in a dimensional modeler’s vernacular. As most of you know, SCD is short-hand for slowly changing dimensions. There are several well-documented techniques for dealing with slowly changing dimension attributes. Briefly, with SCD Type 1, the attribute value is overwritten with the new value, obliterating the historical attribute values. For example, when the […]

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