Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Basic modelling question

3 posters

Go down

Basic modelling question Empty Basic modelling question

Post  podgeypoos 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

Back to top Go down

Basic modelling question Empty Re: Basic modelling question

Post  rammnch 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

Back to top Go down

Basic modelling question Empty Re: Basic modelling question

Post  BoxesAndLines Fri Oct 11, 2013 12:44 pm

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

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

Back to top Go down

Basic modelling question Empty Re: Basic modelling question

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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