Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Model Policies and Coverages

2 posters

Go down

Model Policies and Coverages Empty Model Policies and Coverages

Post  vermarajiv Thu Jan 28, 2010 10:12 pm

Hi all,
Need your help in modeling this. I am in insurance company. It has customers and customers can have more than one policies. Every policies have multiple versions because of renewals or some other change. Every version has 4 or 5 or more coverages with premiums. I can see that Customers and Policy will be dimensions and fctPolicyVersion could be a fact table. Will you keep a separate fact table for coverages and relate it to fctPolicyVersion ? Can two facts be related like this ?

Thanks for all your help.

RK

vermarajiv

Posts : 7
Join date : 2009-12-14

Back to top Go down

Model Policies and Coverages Empty Re: Model Policies and Coverages

Post  user201002 Sat Feb 06, 2010 7:50 pm

I would go with separate coverage fact table. (A separate fact table is a need if there are attributes and metrics specific to coverages.)

user201002

Posts : 1
Join date : 2010-02-06

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum