Basic modelling question

View previous topic View next topic Go down

Basic modelling question

Post  podgeypoos on Thu Oct 10, 2013 5:26 pm

We have two tables
1. Streaming usage fact (holds the subscription info we have for customers, i.e. they pay us $20 a month for the usage of our product)
2. Customer dimension (hold username etc)

A colleague and my self are having a discussion on where the start date of a customer (date their account was created).
I believe it should be added to the Customer dimension as it is something that describes the customer ,is set in stone and is non additive. my colleague thinks it should go into our subscription fact table as the first entry in the subscription.

Where should this nugget of info go?

podgeypoos

Posts : 6
Join date : 2012-11-07

View user profile

Back to top Go down

Re: Basic modelling question

Post  rammnch on Thu Oct 10, 2013 5:41 pm

It should be in DIM table. When you store this record key in fact table you can get customer information along with their subscription date.

rammnch

Posts : 5
Join date : 2013-10-10

View user profile

Back to top Go down

Re: Basic modelling question

Post  BoxesAndLines on Fri Oct 11, 2013 12:44 pm

It should a FK in the fact to the date dimension.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Basic modelling question

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum