Chris Adamson’s Blog

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

This post introduces the concept of the factless fact table and the situations where you would model one. When a fact table does not con...

This post looks at the issues faced when facts can change retroactively. Q: Our source system allows facts to be updated.  We are trying t...