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 » surrogate keys   (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
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement