Multivalued Dimension or Multiple facts w/conformed dimensions

View previous topic View next topic Go down

Multivalued Dimension or Multiple facts w/conformed dimensions

Post  sr_da on Thu Nov 11, 2010 4:34 pm

I am trying to model for insurance industry, with data as follows:

We have data at different levels:
Policy level with related facts. ((Premium , face amount, mode etc)
Policy Fund level (combination with related fact values.)
Policy Rider level (combination with related fact values.)

Now, should I create:

1. Policy dim, policy status dim, product dim etc... along with policy fact.
2. Policy dim, Fund dim, Policy Fund Details Fact
3. Policy dim, Rider dim, Policy Rider Fact.

How would I build a multivalued dimension for the above combination? Is there pros/cons in using either of these two approaches.

Please let me know.

sr_da

Posts : 14
Join date : 2009-10-19

View user profile

Back to top Go down

Re: Multivalued Dimension or Multiple facts w/conformed dimensions

Post  ngalemmo on Thu Nov 11, 2010 9:15 pm

If you have the three fact tables, why would you need a multivalued dimension?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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