All,
We have very large fact tables that contain many overlapping surrogate keys, for performance reasons. For example, an Account Fact table and an Account Value Fact table have both have a dealer surrogate key so you can query the Account Value fact without going through the Account Fact.
How would you go about modeling this without creating possible loop joins?
Hi,
Make sure you have no fact-to-fact relationships defined in FM - the facts will link to your conformed dimensions only.
Regards,
MF.