Indicators in fact table

View previous topic View next topic Go down

Indicators in fact table

Post  chade25 on Wed Feb 13, 2013 2:40 pm

What is your opinion on storing 'Y' and 'N' (yes or no) indicators as 0's and 1's in the fact table?

To be clear this is for a college for student registration. The indicators are for passed indicator, gpa indicator (does the course affect their gpa) , attempted indicator, completed indicator...thats for more clarification.

Thanks!

chade25

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

View user profile

Back to top Go down

Indicators in fact table

Post  rathjeevesh on Sun Feb 17, 2013 2:00 pm

Option to create a Junk dimension may be helpful out here. As most of the flags that you are dealing with will have less distinct value, go ahead and create a junk dimension with all these indicators {passed indicator, gpa indicator (does the course affect their gpa) , attempted indicator, completed indicator} and a surrogate key. Populate the Junk dimension with all combinations for these flags. Check which row in the junk dimension has all flag values same as source record and populate corresponding surrogate key in the fact table for registration. This way your fact table size will be manageable and you can gracefully add more indicators to your dimension in future.

rathjeevesh

Posts : 15
Join date : 2013-02-16

View user profile

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