Consolidating datamarts

by  |  30-Dec-2019 22:59

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.

consolidating datamarts-74

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.

Community Discussion