Chris Adamson’s Blog

Sometimes, the source data for a fact table does not include a transaction identifier. When this happens, we often crate our own. A reader a...

A reader observes that bridge tables seem problematic, and wonders if they should just replaced by factless fact tables. Q:   I am wonder...

I am often asked for feedback on designs that include a "surrogate key for the fact table."  There are two common reasons for whi...