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?
- Posts : 29
Join date : 2012-04-12
Age : 41
Location : Oregon
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.
Permissions in this forum:You cannot reply to topics in this forum