Time Dimension Wizard

Hi all,

When I generate a Time Dimension table using the BIDS Wizard, the resulting table has a Date field as the PK. This means the fact tables will need to have a Date field as a FK to this dimension. Is this the best practice? Should I generate the time dimension another way?

Thanks

Felipe

Best practices says to use a day code like 20120411 (YYYYMMDD) as PK.

So, you should have a day code column in your fact table so you can join with time dimension throught that column.