Fact answering multiple questions

Go down

Fact answering multiple questions Empty Fact answering multiple questions

Post  chade25 on Thu Apr 12, 2012 6:11 pm

Is it advisable to have a fact table that would contain say amounts and stuff for pell grants and accounts recievable and loans, or is it better to simplify it and make a grant_fact table , loan_fact table and so on? Or does it just not matter?

chade25

Posts : 29
Join date : 2012-04-12
Age : 39
Location : Oregon

Back to top Go down

Fact answering multiple questions Empty Re: Fact answering multiple questions

Post  ngalemmo on Thu Apr 12, 2012 7:03 pm

If your intent is to build a data warehouse, a fact table should represent a single business event or state, and be maintained at the lowest level of detail (context) of the event. So, if you are doing a sales fact, it should be the sale at the lowest level of detail (greatest dimensionality). If you do that for any fact, then, information is a simple matter of combining measures along common attributes.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top


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