One Fact vs. Multiple Facts

View previous topic View next topic Go down

One Fact vs. Multiple Facts

Post  Annabr on Sun Nov 24, 2013 4:50 pm

Hello,

I am struggling with a logical dilemma, and will appreciate your advise on the subject.

Let's say I am dealing with Data Model for a store. I have sale transactions on one hand and refund transactions on the other.
I have a 1:1 link between the two types of transactions.
The main dimensions which are setting the granularity of the Facts are the same, however the refund transactions have relationship with additional dimensions, e.g. refund reason dimension.

Should I manage the data of both transaction types in one fact table or should I separate them into two fact tables?
What are the key considerations when deciding on the above?

Thanks,
Anna

Annabr

Posts : 1
Join date : 2013-11-24

View user profile

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