Fact answering multiple questions

View previous topic View next topic Go down

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 : 37
Location : Oregon

View user profile

Back to top Go down

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

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

View user profile http://aginity.com

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