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

Bridge Table - Linking Facts ?

2 posters

Go down

Bridge Table  - Linking Facts ? Empty Bridge Table - Linking Facts ?

Post  iggster 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' ?


Posts : 1
Join date : 2010-10-05

Back to top Go down

Bridge Table  - Linking Facts ? Empty Re: Bridge Table - Linking Facts ?

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

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