1 or 2 Dimensions - Customer & Shipping Address

tonytiger at 08h45
22
Sep
2009
1 or 2 Dimensions - Customer & Shipping Address

I have read the Toolkit book and am doing a little dimensional modelling exercise, but I have come across an issue which I am not sure about.

I have a Customer dimension but I am not sure whether or not to include the shipping address in the Customer dimension. Each Customer typically (95% of the time) has one shipping address with fields that change slowly (I'll use type 2 SCD). But 5% of the time, customers have mu

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Monster Dimensions
My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two
Customer Dimension
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
De-normalizing Customer Information to create a Customer Dimension
I have a question regarding de-normalizing customer data to create a single customer dimension! Let's say our OLTP customer information is made up of 2 tables. 1) Customer Table (customer name, customer type, etc...) 2) Address Table (address1,
Customer addresses in a high volume retail environment
I have a requirement to start capturing addresses in our data warehouse for detailed analysis of customer returns. Up until now, analysis at postal code has been sufficient. The company I work is mail order, so the addresses I need to record
Addresses in Customer Dimension
As part of an Orders dimensional model, I am attempting to design the Customer Dimension table. The customers have multiple sold-to addresses and multiple ship-to addresses. While the OLTP allows any Order to have any combination of sold-to and ship-to
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"1 or 2 Dimensions - Customer & Shipping Address"

This topic has been viewed 1634 times.

Last message :
22/09/2009 at 08h45 by "tonytiger"