allocating or bridge table?
2 posters
Page 1 of 1
allocating or bridge table?
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.
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
Re: allocating or bridge table?
Use a bridge table. It is the perfect situation for its use. Allocation makes no sense as there is nothing to allocate.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» How to resolve a many to many relationship? Bridge Table or Utilize the same fact table?
» separate fact table/different grain - do I need a bridge table
» Data in a fact or dimenzion table or bridge table
» Bridge tables versus massive junk dimensions
» difference between factless fact and bridge table
» separate fact table/different grain - do I need a bridge table
» Data in a fact or dimenzion table or bridge table
» Bridge tables versus massive junk dimensions
» difference between factless fact and bridge table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum