Role differences between facts
2 posters
Page 1 of 1
Role differences between facts
A common scenario in a data warehouse is having two separate entities such as customer and reseller. They are 2 distinct roles and would require their own separate dimensions. My question is what happens when you add a fact table that treats these 2 entities as the same thing such as clickstream data.
For instance, say I have a web store that allows users to buy and sell items and you must be logged in to do so. When a sale is made there is a distinct buyer and a distinct seller which is modeled by 2 separate dimensions. What if I then wanted to add clickstream data to the warehouse? This is analyzed on a user basis and would be cumbersome if customers and resellers had to be treated separately. I can combine everyone into the same table which is what I'm leaning towards but I have a feeling there will be some pitfalls with doing that.
Basically I'm looking for the pros and cons to each method and what the generally accepted way is to do it if there is one. Thanks!
For instance, say I have a web store that allows users to buy and sell items and you must be logged in to do so. When a sale is made there is a distinct buyer and a distinct seller which is modeled by 2 separate dimensions. What if I then wanted to add clickstream data to the warehouse? This is analyzed on a user basis and would be cumbersome if customers and resellers had to be treated separately. I can combine everyone into the same table which is what I'm leaning towards but I have a feeling there will be some pitfalls with doing that.
Basically I'm looking for the pros and cons to each method and what the generally accepted way is to do it if there is one. Thanks!
bcm- Posts : 1
Join date : 2009-08-24
Re: Role differences between facts
Combining them will work fine. Depending on the attributes you may want to implement a subtype table for one or both. The subtype table(s) should have the same primary key as the main dimension.
Similar topics
» How best to model Timesheet facts against Sales Order facts
» Multiple Facts or Single Facts and Status Table?
» Identify the facts and facts grain
» Inventory facts and production facts
» In which layer to relate facts to other facts?
» Multiple Facts or Single Facts and Status Table?
» Identify the facts and facts grain
» Inventory facts and production facts
» In which layer to relate facts to other facts?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|