Forum Discussion

WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
3 years ago

Data Model - More than one fact table?

Hi   I would really appreciate some support with my data model. It is quite complex and I'm getting in a bit of a muddle! I've attached a snapshot but it's a bit scruffy and I've attempted to blank...
Need Help
WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
3 years ago

Sorry, this is helpful advice but I'm still slightly going around in circles. Intervention is a relatively important table as there are several measurements related to completing the intervention.

I think a combination of an offence ID and outcome ID should be a FACT table with Outcome date.
However, the same comination of offence ID and outcome ID will be linked to an intervention. I'm still a bit confused re how I would represent this without recreating the same combination in both FACT tables