Customer Both as Fact and Dimension

View previous topic View next topic Go down

Customer Both as Fact and Dimension

Post  ohmycamote on Tue Jul 05, 2011 2:41 pm

In our business, our customers are subscribers so they can be active or inactive status.
Part of the reporting requirements is to show how many subscribers there are based on when they joined.

So is it best to do this via a Factless Fact table?
E.g.,

FACTCUSTOMERS
- FACTCUSTKEY (PK)
- CUSTKEY (FK)
- JOINDATE_KEY (FK)

DIMCUSTOMERS
- CUSTKEY (PK)
- RECORD_STATUS (SCD)
- STARTDT (SCD)
- ENDDT (SCD)

Is this the right way to do this?

Thanks

ohmycamote

Posts : 14
Join date : 2011-07-05

View user profile

Back to top Go down

Re: Customer Both as Fact and Dimension

Post  ngalemmo on Tue Jul 05, 2011 3:43 pm

Customer is a dimension, never a fact. The fact in question is subscription, not customer. You would have a subscription fact table of which customer is one of the dimensions.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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