Basic modelling question
3 posters
Page 1 of 1
Basic modelling question
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?
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
Re: Basic modelling question
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
Re: Basic modelling question
It should a FK in the fact to the date dimension.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» basic question, change DIM table
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
» Modelling Question
» Multiple measures in a fact table- modelling question
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
» Modelling Question
» Multiple measures in a fact table- modelling question
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum