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

One Fact vs. Multiple Facts

Go down

One Fact vs. Multiple Facts Empty One Fact vs. Multiple Facts

Post  Annabr 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

Back to top Go down

Back to top

- Similar topics

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