I have a fact table that will have a column which will hold one of two values (occupied/vacant). Is it necessary to create a Dim table for this?
+3
A:
If you just need a count of cases then Occupancy is a measure with values 0/1 and not a dimension, so you wouldn't have a dimension table.
If you want to, I dunno, analyse Rents & Taxes by Occupancy and Region then Occupancy is a dimension. Again it should be stored as 0/1 because reducing column width is imperative in the Fact Table. Your reporting tool may allow you store a translation of 0/1 as metatdata, but you are better off with a dimension table, because this keeps your data warehouse application neutral.
cindi
2009-02-18 12:12:53