It can be done with a dimensional scheme or with a normalised schema. Ralph Kimble argues for the dimensional approach whilst Bill Imon argues for the normalised approach.
For myself, I tend to go with Kimble, but there are advantages and disadvantages to both approaches. Wikipedia has a decent summary of this here:
For myself, I tend to go with Kimble, but there are advantages and disadvantages to both approaches. Wikipedia has a decent summary of this here:
https://en.m.wikipedia.org/wiki/Data_warehouse#Dimensional_v...