|
meth73
Starting Member
Australia
10 Posts |
 Posted - 06/09/2012 : 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 PK
DateKey int
CaseID int
<various attributes that change over time>
Fact Table 2:
-------------
ID int PK
DateKey int
CaseID int
SLO_ID int
Result 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. |
|
Drill Across, 2 snapshot Fact tables
