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

Multivalued Dimension or Multiple facts w/conformed dimensions

2 posters

Go down

Multivalued Dimension or Multiple facts w/conformed dimensions Empty Multivalued Dimension or Multiple facts w/conformed dimensions

Post  sr_da 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

Back to top Go down

Multivalued Dimension or Multiple facts w/conformed dimensions Empty Re: Multivalued Dimension or Multiple facts w/conformed dimensions

Post  ngalemmo Thu Nov 11, 2010 9:15 pm

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

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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