Our college is making a data warehouse and we were thinking of having a fact table that is kind of an overview of for a student which links to a transaction fact table to give a more detailed view of each transaction code. So, I could see that they have an account balance in the student fact table along with pell grant amount for a given term, but we were thinking of adding a table to link to that to see the details. Is this advisable?
- Posts : 29
Join date : 2012-04-12
Age : 43
Location : Oregon
In dimensional terms, you have two fact tables that share student as one of the dimensions. In your use case, drilling into details involves a separate query against the detail fact using known, common dimensional values (i.e. filter on student, semester). You don't need to 'join/link the fact tables'.
Permissions in this forum:You cannot reply to topics in this forum