I'm no DBA, so I won't dwell too much on the techie stuff like expanding the temp space or moving it to a disk with more free capacity etc. ...

In Kimball solutions I have seen, the surrogate date_key tends to only exist on the fact tables. On all the dimension tables they tend to be normal DATE datatypes....

Hi All,

Your answers are unanimous for the date dimension. Thanks - especially to Jez for some good real world reasons. My DW will have a date dimension and...

Hi Stephanie,

My view is that you should always think of the end users first. End users want consistency and a single view of the customer. They don't want...