2 ms·
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 normalise
by chris_wot 11y ago
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:
https://en.m.wikipedia.org/wiki/Data_warehouse#Dimensional_vs._normalized_approach_for_storage_of_data https://en.m.wikipedia.org/wiki/Data_warehouse#Dimensional_v...