Kimball GroupJune 2009 - Kimball Group
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact
  • More about the Kimball Group Reader (Kimball/Ross, 2016)

Kimball Group

More about the Kimball Group Reader (Kimball/Ross, 2016)
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact

Monthly Archives: June 2009

  • Home /
  • All Tips/
  • 2009 /
  • June

Design Tip #113 Creating, Using, and Maintaining Junk Dimensions

  • Warren Thornthwaite
  • June 3, 2009

A junk dimension combines several low-cardinality flags and attributes into a single dimension table rather than modeling them as separate dimensions. There are good reasons to create this combined dimension, including reducing the size of the fact table and making the dimensional model easier to work with. Margy described junk dimensions in detail in Kimball Design Tip #48: […]

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
  • Technical Architecture
  • Business Intelligence Applications

Archives

  • 2015
    • December
    • November
    • October
    • September
    • July
    • June
    • May
    • March
    • February
    • January
  • 2014
    • July
    • June
    • May
    • March
    • January
  • 2013
    • August
    • June
    • May
    • February
  • 2012
    • July
    • May
    • February
  • 2011
    • November
    • August
    • June
    • May
    • April
  • 2010
    • December
    • October
    • September
    • February
  • 2009
    • October
    • August
    • June
    • May
    • March
  • 2008
    • November
    • September
    • August
  • 2007
    • December
    • October
    • July
  • 2006
    • July
    • June
  • 2005
    • December
    • March
  • 2004
    • October
    • March
    • February
    • January
  • 2003
    • October
    • June
    • April
    • March
    • February
    • January
  • 2002
    • November
    • September
  • 1999
    • December
  • 1998
    • December
    • May
  • 1997
    • August
    • July
  • 1995
    • December
The Kimball Group. All Rights Reserved. Spark Logix Studios