Category: Data Warehousing

Some very nice articles, for reference:

• David Stein – What exactly are Dimensions, and why do they slowly change?
• Jamie Thomson – Debunking Kimball Effective Dates
• Jamie Thomson – Debunking Kimball Effective Dates, part II: Windowing functions

Oops, Jamie Thomson seems to have vanished from the web. However, his posts are still available via the Wayback Machine:

• Archived: Debunking Kimball Effective Dates
• Archived: Debunking Kimball Effective Dates part II – Windowing functions