allocating or bridge table?

View previous topic View next topic Go down

allocating or bridge table?

Post  dellsters on Fri May 29, 2009 1:49 pm

I'm trying to decide whether I should allocate or use a bridge table in my star schema.
From a business perspective, the most granular level is at the visit level. A visit can have multiple procedures.

It doesn't make sense to bring the grain to the procedure level. I'm wondering if I should just use a bridge table and keep the grain at visit level.


Last edited by dellsters on Thu Apr 08, 2010 12:35 pm; edited 1 time in total

dellsters

Posts : 39
Join date : 2009-02-11

View user profile

Back to top Go down

Re: allocating or bridge table?

Post  BoxesAndLines on Sun May 31, 2009 10:28 pm

Use a bridge table. It is the perfect situation for its use. Allocation makes no sense as there is nothing to allocate.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

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