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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-05 : 00:11:14
|
| Chris writes "Hello,In SQL Server 2000 I'm developing a DataWarehouse. I have a OrderFact table and a OrderDetailsFact table. Would you recommend duplicating a lot of the data in the OrderDetails table that is in the Order table or is it better to just import the extra data for the details and link the OrderNumber from the OrderDetails to the Order table to get the various header type info.Pardon me if I've already asked you this question, for some reason I'm getting a sense of deja vu.Thanks" |
|
|
|
|
|
Fact Detail Table