I'm currently defining a fact table in my first datacube and have a question (basic one albeit). Can a datetime column be left in a fact table as a measure or should this be stored only within a dimension table? The other columns I have left
in thus far are foreign keys for the dimension tables.
Any pointers appreciated.
View Complete Post