Customer Age

jryan at 17h26
27
Sep
2010
Customer Age

Hi,

Does anyone know the best way to model customer age? I guess there are 3 options: 1)Just their birth date, 2)Their current age as an attribute, 3)their age as an attribute but make it a type 2 scd so that you get all their age history.

This is for a sales model. Ideally I'd like to know the age that a customer was when they bought a particular product. However, having age as a type 2 scd just doesn't seem quite right to me.

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
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
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,
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
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
Hi All, I design customer dimensions, but in our concept we have two types of customer the customer as the owner and the customer as one member in customer group which we call it contract,and some times the contract is the owner One-To-one . From this
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Customer Age"

This topic has been viewed 1464 times.

Last message :
27/09/2010 at 17h26 by "jryan"