Many cases for each Fact
2 posters
Page 1 of 1
Many cases for each Fact
Hello
I'm trying to do an education model
Each Student has one record (fact) for each Course (with only semi-additives, by now)
The issue is that each Course is teached by one or more Teachers
when the user (an academic authority) would query "by Course", they should get the same results for every teacher
like a 1 to many relationship...
I think I could make a junk dim with each "teacher staff", concatenating them by "," ( loosing this way quality attributes like age, etc )
I could repeat each fact several times, one for each Teacher ( which would increase an average of 3 times the space needed for the data )
Is there another possibility?
thanks!!!
I'm trying to do an education model
Each Student has one record (fact) for each Course (with only semi-additives, by now)
The issue is that each Course is teached by one or more Teachers
when the user (an academic authority) would query "by Course", they should get the same results for every teacher
like a 1 to many relationship...
I think I could make a junk dim with each "teacher staff", concatenating them by "," ( loosing this way quality attributes like age, etc )
I could repeat each fact several times, one for each Teacher ( which would increase an average of 3 times the space needed for the data )
Is there another possibility?
thanks!!!
bajopalabra- Posts : 12
Join date : 2012-08-24
Age : 49
Re: Many cases for each Fact
you can construct student, cource, teacher dimensions along with the bridge dimension of student-course, course-teacher to resolve the many-many relationship to handle this.
murugan2012- Posts : 5
Join date : 2012-08-22
Re: Many cases for each Fact
ok, I didn't know about bridge dimensions, I'm going to read about it right now, thanks
bajopalabra- Posts : 12
Join date : 2012-08-24
Age : 49
Re: Many cases for each Fact
I wonder if "bridge tables" doesn't break the star schema... does it?
bajopalabra- Posts : 12
Join date : 2012-08-24
Age : 49
Similar topics
» Cost plans for projects - One fact table or several fact tables?
» Multiple Fact Tables vs. Consolidated Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Unknown number of relationships from dimension to fact until fact loaded
» Multiple Fact Tables vs. Consolidated Fact Table
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
» Unknown number of relationships from dimension to fact until fact loaded
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum