Hi everybody,
I'm creating a new data mart and was wondering what kind of datatype you would recommand to use for the time dimension PK.
Kimball recommands to allways use numbers but personaly I would prefere to use a date so that the range partitioning of the fact table would be simpler.
Regards
Mike