Modeling Conformed Dimensions

[c8guru]

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?

[MFGF]

Hi,

Make sure you have no fact-to-fact relationships defined in FM - the facts will link to your conformed dimensions only.

Regards,

MF.