Bridge Table - Linking Facts ?

View previous topic View next topic Go down

Bridge Table - Linking Facts ?

Post  iggster on Tue Oct 05, 2010 2:00 am

We are recording 2 sets of facts - Financial Trades and Trade Warnings. Trades Warnings occur when a certain set of related Financial Trades hit some programmed criteria. We need to to link the Trade Warning with the Financial Trades that caused the warning.

Clearly in normal E-R modelling we could create a many-to-many association (a single Financial Trade can be linked to multiple Warnings and visa-versa). Whilst it is considered 'bad form' to link (and potentially join) FACT tables I can't see any other way to do it. What are the alternatives ? And if we do create this Bridge table, is it a fact , a dimension or something else e.g. 'BRIDGE' ?

iggster

Posts : 1
Join date : 2010-10-05

View user profile

Back to top Go down

Re: Bridge Table - Linking Facts ?

Post  BoxesAndLines on Tue Oct 05, 2010 9:40 am

It is not bad form to join fact tables. You do this by "drilling across" using a common (i.e. conformed) dimension. A bridge table allows for a fact to relate to a given dimension 1..n times. Some folks like to add an allocation amount to the bridge table for financial transactions or in health care the primary diagnosis for example.
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