Storing Letter grades

View previous topic View next topic Go down

Storing Letter grades

Post  chade25 on Wed Feb 13, 2013 7:18 pm

At our school, we have letter grades and I want to record them to the fact table. There really is only one attribute (like 'A+') but it etl tool doesnt allow this but I only want to supply it with a surrogate key and write that to the fact table. Thoughts?

chade25

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

View user profile

Back to top Go down

Re: Storing Letter grades

Post  BoxesAndLines on Thu Feb 14, 2013 10:16 am

I would store the grade values as a dimension. The fact table sounds like a factless fact.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Storing Letter grades

Post  Jeff Smith on Thu Feb 14, 2013 10:46 am

Just curious, but is there a numerical value associated with the Grade which is used to calculate the Grade Point Average?

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Storing Letter grades

Post  hkandpal on Thu Feb 14, 2013 11:22 am

Hi ,
the best approach is to store in dimension and have one more numeric column which will help in identifying if A+ > A, if you need to compare grades.

thanks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Storing Letter grades

Post  chade25 on Thu Feb 14, 2013 12:18 pm

Yeah there is quality points which can refer to an A, but I am putting that on the fact table as well. Do you think I should keep that in the dimension? Its fine but the lower bound of the A is kept in the A- record, which is ok, just means more ETL to have a to and from

chade25

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

View user profile

Back to top Go down

Re: Storing Letter grades

Post  Jeff Smith on Thu Feb 14, 2013 6:04 pm

You could have the point value in both the fact and Dimension - doesn't hurt. I would add columns that contained things like "Pass/Fail/Other" (the other would be an incomplete). It's a small dimension so adding things to make it easier to query won't cost anything.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Storing Letter grades

Post  Sponsored content


Sponsored content


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