Model Policies and Coverages

View previous topic View next topic Go down

Model Policies and Coverages

Post  vermarajiv on 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

View user profile

Back to top Go down

Re: Model Policies and Coverages

Post  user201002 on 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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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