Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DaliJano
Starting Member
1 Post |
 Posted - 2009-11-28 : 05:56:35
|
| Hi,in my fact table there is a date in this format "21.1.2009 0:00:00"and I want create a time dimension.I can split the date into day, month, year, but the question is, how to add a foreign key to the fact table. Does anybody have an example how to add a time dimension table and add a foreign key to the fact table???Cheers |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-11-28 : 13:31:51
|
| usually the key that we use for time dimension will represent the date itself i.e like 20090121 for 21.1.2009 |
 |
|
|
|
|
|
BI - Time Dimension