THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » data warehousing   (RSS)
  • Data Warehouse modelling deliberations – foreign keys and unknown members

    Earlier today I posted the following question on Twitter: Foreign keys in a data warehouse. Yes or no? This discussion is looming at work, i know my position but am interested in what others think. ( Specifically, I wanted to know if people were in favour of creating foreign keys ...
    Posted to Jamie Thomson (Weblog) by jamiet on April 16, 2013
  • 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 this approach in his paper Slowly Changing Dimensions, Types 2 & 3 from the October 2008 ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 28, 2009
  • Considering surrogate keys for Unknown members

    All data warehouses have the notion of an Unknown member somewhere in their make-up. That is, a dimension member to which we can map fact records when the member that we need to map to is, well, unknown. The canonical example of where the Unknown member becomes useful is in a retail environment where the retailer uses a customer loyalty card that ...
    Posted to Jamie Thomson (Weblog) by jamiet on October 14, 2009
Privacy Statement