Transformation to populate 'date' dimension

[MattCasters]

Attachment: populate date dimension.xml Hi,
In attachement you will find a simple transformation that populates a date dimension.
(1950-2050)


Have fun with it!



Matt

[TobiasRoth]

This transformation is incorrect. It labels 2006-01-01 as Monday, but that day in fact was a Sunday. I guess the error happened because of the age-old discussion about whether the week starts at Monday or Sunday. The 'Calculator Step' (imo correctly) thinks the day one of a week is Sunday, but the step where the names of weekdays are generated thinks the first day in a week is Monday.

I changed the 'DayOfWeekDesc Gen' step to start with Sunday to fix this.

Thanks,
Tobias

[MattCasters]

You are so right. I was indeed thrown off by the stupid American way of starting the week on a Sunday. :-)

Thanks for pointing that out. (the above attachment has been replaced)

All the best,
Matt

[TobiasRoth]

Actually, Wednesday in german is called 'Mittwoch', which means something along the lines of 'Mid-Week'. If you consider that, starting the week at Sunday suddenly makes sense again... :-)