Indicators in fact table
2 posters
Page 1 of 1
Indicators in fact table
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!
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
Indicators in fact table
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
Similar topics
» Factless Fact Table can contain Flags (Yes or No)
» Fact or Profile dim for indicators ?
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
» Fact or Profile dim for indicators ?
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» How to create fact table with measures derived from comparing two fact table rows
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum