O'Reilly logo
  • Thibault Drevon thinks this is interesting:

These fact tables are uniformly dense in their foreign keys because even if no activity takes place during the period, a row is typically inserted in the fact table containing a zero or null for each fact.

Note

Interesting difference with atomic transaction facts.