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

Customer and Factless Fact Table(s)

2 posters

Go down

Customer and Factless Fact Table(s) Empty Customer and Factless Fact Table(s)

Post  MarkSe Mon Jul 25, 2011 6:24 am


Have just started looking at the design of the Customer dimension and some "related" dimensions.
As Customers can have > 1 address, am planning to have separate Customer and Address dimension tables - and then a Factless fact table for dimensional reporting.

but
in the source database, there are several other relationships from the Customer table in addition to the CustomerAddress - e.g. CustomerName, CustomerPhone etc... (there are over 10 in total)
should i be creating a separate Factless fact table for each / every one of these combinations - or is there some other possible solution ??

MarkSe

Posts : 5
Join date : 2011-07-21

Back to top Go down

Customer and Factless Fact Table(s) Empty Re: Customer and Factless Fact Table(s)

Post  BoxesAndLines Mon Jul 25, 2011 9:00 am

Customer Name table?? I would just put "domain" type entities into the customer dimension table. The same for phone as well. I have also been known to snowflake the addresses off of customer dim as well.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

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