Joining Fact tables

[chade25]

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?

Thanks!

[ngalemmo]

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'.