Browse by Tags

• data modelling
• data warehousing
• denali
• sql
• sql server
• SQL Server 2012
• t-sql
• Windowing Functions

• Debunking Kimball Effective Dates part 2 – Windowing Functions

  Reigniting the [SCDEndDate] debate In November 2009 I wrote a blog post entitled Debunking Kimball Effective Dates where I stated that I was against the Kimball-recommended practice of maintaining a StartDate & EndDate value for every record in a Read More... Posted Wednesday, July 13, 2011 7:31 PM by jamiet | 16 Comments Filed under: t-sql, sql server, Kimball, denali, Windowing Functions, SQL Server 2012

• Debunking Kimball Effective Dates

  Those who are familiar with Ralph Kimball’s theories on data warehousing modelling may be familiar with his assertion that a type 2 dimension member record should have a StartDate and an EndDate that defines the effective period of that record. He outlines Read More... Posted Saturday, November 28, 2009 4:59 PM by jamiet | 56 Comments Filed under: data warehousing, sql, data modelling, Kimball