• Personally I would go for option 1. I don't really like keys to other fact tables in the design.

    And I would add the entire history in the new fact table, if possible. That way your old fact table is just a rollup of the new fact table.

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