Customer and Factless Fact Table(s)
2 posters
Page 1 of 1
Customer and Factless Fact Table(s)
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
Re: Customer and Factless Fact Table(s)
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- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Fact Table or Factless Table: Please Suggest
» Same attribute in multiple dimensions or Create new dimension?
» Factless Fact Table can contain Flags (Yes or No)
» difference between factless fact and bridge table
» Help with design of Factless Fact Table SCD
» Same attribute in multiple dimensions or Create new dimension?
» Factless Fact Table can contain Flags (Yes or No)
» difference between factless fact and bridge table
» Help with design of Factless Fact Table SCD
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum