Fact answering multiple questions
2 posters
Page 1 of 1
Fact answering multiple questions
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 : 44
Location : Oregon
Re: Fact answering multiple questions
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.
Similar topics
» Modeling multiple multivalued dimensions and other design questions
» modelling questions & answers dimensions where answer can be multiple choice or freetext
» How to handle multiple aggregations for multiple KPIs in fact table
» Questions about modelling an event fact table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» modelling questions & answers dimensions where answer can be multiple choice or freetext
» How to handle multiple aggregations for multiple KPIs in fact table
» Questions about modelling an event fact table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum