modeling question

View previous topic View next topic Go down

modeling question

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

View user profile

Back to top Go down

Re: modeling question

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: modeling question

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

View user profile

Back to top Go down

Re: modeling question

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: modeling question

Post  Sponsored content


Sponsored content


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