Is it a fact or a dimension?

View previous topic View next topic Go down

Is it a fact or a dimension?

Post  gbaren on 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

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Is it a fact or a dimension?

Post  modeling12345 on 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

View user profile

Back to top Go down

Re: Is it a fact or a dimension?

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Is it a fact or a dimension?

Post  Sponsored content


Sponsored content


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