Summarized data with detail
2 posters
Page 1 of 1
Summarized data with detail
My example is this: Storing registration event for students at a university, then having columns to say their institutional GPA up to that point of the event, Overall GPA up to the point of that event and their GPA for just that term they registered for (when grades show up ). Is this bad to do? Is it bad as well to join this detail fact table to a summary fact table which would have the sum of the persons Credit hours earned that was transferred from another institution?
Thanks guys.
Thanks guys.
chade25- Posts : 29
Join date : 2012-04-12
Age : 44
Location : Oregon
RE: Summarized data with detail
We are advised to store data in a fact table that conform to the grain of the fact. Mixing summary and detail data together impose query challenges and consistency in output.
"having columns to say their institutional GPA up to that point of the event, Overall GPA up to the point of that event" is ok to store along with registration fees etc. "their GPA for just that term they registered for" once the term is over then you have to update the value in the fact and that is ok too.
There is no problem joining a details fact with summary fact table as long as you have conformed dimension to resolve the join path.
-JR
"having columns to say their institutional GPA up to that point of the event, Overall GPA up to the point of that event" is ok to store along with registration fees etc. "their GPA for just that term they registered for" once the term is over then you have to update the value in the fact and that is ok too.
There is no problem joining a details fact with summary fact table as long as you have conformed dimension to resolve the join path.
-JR
rathjeevesh- Posts : 15
Join date : 2013-02-16
Similar topics
» Query Using Aggregate or Detail Data
» Extracting Master/Detail data into Staging Tables
» data model for 2 fact tables (Header / Detail scenario)
» Data Modelling -- linking Header and Detail Fact Tables.
» ETL Subsystem 5 - Error Event Schema
» Extracting Master/Detail data into Staging Tables
» data model for 2 fact tables (Header / Detail scenario)
» Data Modelling -- linking Header and Detail Fact Tables.
» ETL Subsystem 5 - Error Event Schema
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum