Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Indicators in fact table

2 posters

Go down

Indicators in fact table Empty Indicators in fact table

Post  chade25 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 : 44
Location : Oregon

Back to top Go down

Indicators in fact table Empty Indicators in fact table

Post  rathjeevesh 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

Back to top Go down

Back to top

- Similar topics

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