Joining Fact tables

Go down

Joining Fact tables Empty 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 : 39
Location : Oregon

Back to top Go down

Joining Fact tables Empty 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'.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top


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