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 |
|
vasu4us
Posting Yak Master
102 Posts |
 Posted - 2006-05-12 : 11:37:27
|
| hi all,Iam new to DTS and iam in a datawarehousing proj. iam almost through creating dimension tables now i have to get all the measures into a fact table iam wondering how doi go about it. the plan is to add all the primary keys of dimension tables into fact as fk and create a unique key for fact table. so far so good but how to join the tables and get all the measures from diff tables into one.any suggestions or any links to meterial appriciatedthanksVasu |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-05-17 : 04:28:23
|
| Do a search in google is my best advice, here is a link that would be useful for doing joins on dimenson tables,http://blogs.conchango.com/christianwade/archive/2005/04/07/1255.aspx |
 |
|
|
|
|
|
new to DTS and Datawarehousing