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 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. (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
  • 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
  • Madison is shipping to TAP customers

    They call it their new, massively scalable data warehousing solution; they say it can load 1TB per hour and support data warehouses in the petabyte range, all on commodity hardware.  Bold claims, for sure, and I bet you're thinking, ''I'll believe it when I see it.'' If you can get on Microsoft's TAP list (TAP = Technical Adoption Program) ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on August 24, 2009
  • Sample Chapter: "Building a Data Warehouse: With Examples in SQL Server", Chapter 1: "Introduction to Data Warehousing"

    Go to File Gallery to Download Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing ...
    Posted to Sample Chapters (Weblog) by Sample Chapters on March 15, 2008
Privacy Statement