Should a True/False value be a dimension
4 posters
Page 1 of 1
Should a True/False value be a dimension
Should a true/false attribute be in the Fact table or a Dimension?
Re: Should a True/False value be a dimension
It depends...
If it is logically related to other attributes then it should be in the same Dim as those attributes
If you have a number of unrelated flags then consider putting them in a Junk dimension
If this is a standalone attribute then put it on your fact table as a degenerate dim
If it is logically related to other attributes then it should be in the same Dim as those attributes
If you have a number of unrelated flags then consider putting them in a Junk dimension
If this is a standalone attribute then put it on your fact table as a degenerate dim
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
boolean flags
I concur, but I wouldn't put it on the fact, even if it was a standalone attribute. I'd create a junk dimension from the get-go, because it will be easier to extend gracefully in future and experience says you'll probably find more of the same later.
If it was on the fact, I wouldn't call it a degenerate dimension, by the way- that term tends to be reserved for the types of dimension key that don't warrant other descriptive attributes, like invoice numbers.
If it was on the fact, I wouldn't call it a degenerate dimension, by the way- that term tends to be reserved for the types of dimension key that don't warrant other descriptive attributes, like invoice numbers.
rjback- Posts : 1
Join date : 2015-04-17
Re: Should a True/False value be a dimension
Do you count the number of times something is true or false? If yes, fact.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» many to many troubles
» Help with true one-to-many relationship
» Bridge table for patient diagnosis
» bridge table and junk dimension on customer dimension (bank/credit union)
» many to many troubles
» Help with true one-to-many relationship
» Bridge table for patient diagnosis
» bridge table and junk dimension on customer dimension (bank/credit union)
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum