Kimball GroupJune 2014 - 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 2014

  • Home /
  • All Tips/
  • 2014 /
  • June

Design Tip #167 Complementary Fact Table Types

  • Bob Becker
  • June 17, 2014

There are three fundamental types of fact tables in the data warehouse presentation area: transaction fact tables, periodic snapshot fact tables, and accumulating snapshot fact tables. Most DW/BI design teams are very familiar with transaction fact tables. They are the most common fact table type and are often the primary workhorse schema for many organizations. […]

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