Kimball GroupJuly 2006 - 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: July 2006

  • Home /
  • All Tips/
  • 2006 /
  • July

Design Tip #81 Fact Table Surrogate Key

  • Bob Becker
  • July 6, 2006

Meaningless integer keys, otherwise known as surrogate keys, are commonly used as primary keys for dimension tables in data warehouse designs. Our students frequently ask us – what about fact tables? Should a unique surrogate key be assigned for every row in a fact table? Although for the logical design of a fact table, the answer is no, […]

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