Browse by Tags

• data modelling

• 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 Read More... Posted Tuesday, April 16, 2013 11:36 PM by jamiet | 8 Comments Filed under: data modelling, data warehousing, surrogate keys

• 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 Read More... Posted Wednesday, October 14, 2009 11:35 PM by jamiet | 15 Comments Filed under: data warehousing, surrogate keys