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

Is it a fact or a dimension?

3 posters

Go down

Is it a fact or a dimension? Empty Is it a fact or a dimension?

Post  gbaren Thu Jan 30, 2014 4:00 pm

The fact is an atomic financial transaction. Each transaction results in 0 to n contributions, each a certain percentage of the transaction.

In the source database, these are related tables, call them Transaction and Contribution, where Contribution has a foreign key to Transaction.

The question is this: Should Contribution be a Fact or a Dimension? If it is a fact, how should I join them?

gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

http://equalsql.wordpress.com

Back to top Go down

Is it a fact or a dimension? Empty Re: Is it a fact or a dimension?

Post  modeling12345 Thu Jan 30, 2014 4:50 pm

Not enough details, but based on the information, contribution sounds like a dimension

modeling12345

Posts : 2
Join date : 2014-01-30

Back to top Go down

Is it a fact or a dimension? Empty Re: Is it a fact or a dimension?

Post  ngalemmo Fri Jan 31, 2014 12:36 am

It sounds like both are facts.  The contribution fact would contain transaction ID as a degenerate dimension, so would the transaction fact.  It would probably also have many of the same dimensions as the transaction facts plus those related to the contribution. There would not be a foreign key from contribution to transaction.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Is it a fact or a dimension? Empty Re: Is it a fact or a dimension?

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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