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?
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.