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

allocating or bridge table?

2 posters

Go down

allocating or bridge table? Empty allocating or bridge table?

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

Back to top Go down

allocating or bridge table? Empty Re: allocating or bridge table?

Post  BoxesAndLines 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.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

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