Centipede fact tables

The fact table in a dimensional schema is naturally highly normalized and compact.

Solution:

• prioritize to correlate multiple dimensions into a single dimension