• Is a claim bound in any way to a policy? If yes and claim is just a smaller level of detail of a policy, than I would create just one fact table at the claim level.

    If you need data at the policy level, you just aggregate it.

    It's a best practice to create your fact tables at the lowest level of detail (aka the grain) possible.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP