Koen Verbeeck (8/8/2013)
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.
Yep +1 🙂
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe