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 |
|
meth73
Starting Member
10 Posts |
 Posted - 2012-06-09 : 20:53:32
|
| I understand that it is bad practice to attempt to join Fact tables, and I've tried reading through a lot of the Kimball material, but am yet to identify something that will point me in the right direction.Fact Table 1:-------------ID int PKDateKey intCaseID int<various attributes that change over time>Fact Table 2:-------------ID int PKDateKey intCaseID intSLO_ID intResult bit<various attributes that change over time>The issues is that Fact table 1 to Fact table 2 has a 1-to-many relationship.One option might be to combine both Fact tables into 1 table, but this might require using a distinct count for the measures, and there could be other drawbacks in going down this path.Some suggestions on the way forward would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Drill Across, 2 snapshot Fact tables