Joining Fact tables

View previous topic View next topic Go down

Joining Fact tables

Post  chade25 on Thu Apr 12, 2012 4:39 pm

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!

chade25

Posts : 29
Join date : 2012-04-12
Age : 37
Location : Oregon

View user profile

Back to top Go down

Re: Joining Fact tables

Post  ngalemmo on Thu Apr 12, 2012 5:09 pm

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

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum