Following on from my previous post, in some data warehouses there is a separate dimension for time of day, so that demand through a day can be modelled.
I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to Sky Drive.
You are welcome to have a look at it even if you couldn’t make one of the four venues I am…
In some cases, the differences are more semantic than substantive in nature.
For example, both approaches collect data from source systems into a single data store, from which data marts are populated.
But in reality, the differences are not as stark as they may appear.