aaa121 (8/8/2013)
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?
If the risk and premium class have fixed number of combinations, the mini-dimension is probably a good idea.
I do think you'd drop the policy risk dimension though, and add a surrogate key into the fact table(s), so that your policy dimension stays small. This way, the risk/premium class is directly tied to the facts.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP