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

modeling question

2 posters

Go down

modeling question Empty modeling question

Post  cpeterson Tue Feb 07, 2012 1:00 pm

What is the proper modeling approach to the following...

I have a litigation factless fact table that stores a row (1) whenever an insurance claim becomes a suit. Off of the litigation fact there is a defense firm dimension. How do I model for the situation that there can be more than one def firm assigned to suit at the same time?


cpeterson

Posts : 9
Join date : 2011-11-26

Back to top Go down

modeling question Empty Re: modeling question

Post  ngalemmo Tue Feb 07, 2012 2:18 pm

Either multiple rows in the fact or a bridge between fact and dimension. Since there are no measures, the former is simpler and equally effective.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

modeling question Empty Re: modeling question

Post  cpeterson Tue Feb 07, 2012 2:41 pm

There is a count of 1 in the fact table to sum the number of events. If I put one row in the fact table for each firm associated with the event I run the risk of over counting. It looks like the bridge table is the way to go can you elaborate on the "bridge" table?

cpeterson

Posts : 9
Join date : 2011-11-26

Back to top Go down

modeling question Empty Re: modeling question

Post  ngalemmo Tue Feb 07, 2012 3:54 pm

Or you have an event ID (surrogate or otherwise) in the fact and do a count (distinct event_id). This avoids double counting and eliminates the need for a '1' column.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

modeling question Empty Re: modeling question

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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