• Thanks for your time on this. The conclusion I kept coming to was two fact tables as well.

    What did you think about the mini dimension solution for those more frequently changing attributes?