THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » data warehousin... » data modelling   (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. (https://twitter.com/jamiet/status/324215986729385986) 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement