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 |
|
nimrodm
Starting Member
12 Posts |
 Posted - 2010-10-25 : 13:34:58
|
| Hello,I want to build a data warehouse.What are the cons/pros of adding a time dimensional table which is connected to the fact table by ids ?I will be glad to recieve any ideas and comments.Thanks,Nimrod |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-10-26 : 19:27:11
|
| Usually a time dimension table is linked to a fact table by the datekey. Are you talking about using surrogate keys instead of the actual date?If you go to www.ssas-info.com, there are several articles on time dimensions. Also check out www.bidn.com.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
nimrodm
Starting Member
12 Posts |
Posted - 2010-10-27 : 08:37:03
|
| Thanks for your response but I'm looking for information about structure of databases.Your links related to SSAS dimensions and I want to understand how to create sql server table for time dimension in the best way (of course, according to my needs). |
|
|
|
nimrodm
Starting Member
12 Posts |
Posted - 2010-10-27 : 08:38:40
|
quote:
Originally posted by nimrodm
Thanks for your response but I'm looking for information about structure of databases.Your links related to SSAS dimensions and I want to understand how to create sql server table for time dimension in the best way (of course, according to my needs).
and yes, it's my meaning.. |
|
|
|
|
|
|
Time Dimension in Data Warehouse