Joining Fact tables
2 posters
Page 1 of 1
Joining Fact tables
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!
Thanks!
chade25- Posts : 29
Join date : 2012-04-12
Age : 44
Location : Oregon
Re: Joining Fact tables
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'.
Similar topics
» Joining fact tables
» Joining two Fact tables???
» Joining fact tables
» DegenerateDimension joining Fact tables
» Joining Multiple Fact Tables
» Joining two Fact tables???
» Joining fact tables
» DegenerateDimension joining Fact tables
» Joining Multiple Fact Tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum