• benjamin.seidle (5/1/2015)


    Is this kinda what you are thinking? http://www.kimballgroup.com/2012/02/design-tip-142-building-bridges/%5B/quote%5D

    Not really. A bridge table (as described in the above) is useful when you have to represent a many-to-many relationship between a fact and dimension, or between 2 dimensions (which will really be nothing more than a fact-less fact).

    If you design the structure as I suggested, the fact table will describe all the necessary relationships between physicians and geography, and no bridge table should be required in my opinion.

    If you need to be able to describe the relationship between physician and geography in the absence of a fact record, then you'll have to use a bridge table (or fact-less fact) to represent that relationship.