• Completely agree: http://www.kimballgroup.com/2001/11/03/design-tip-30-put-your-fact-tables-on-a-diet/

    I also forgot. NEVER, EVER, under ANY circumstance, leave null values in your dimension keys. It puts too much at risk for an end user. Look up "surrogate nulls" for more information 🙂