Factless Fact table — not so absurd it may sound at first
We use Fact tables to store our facts, right? So how can a factless table even make remotely sense?
In order to understand this concept of factless fact tables, I want to remind you first that a fact and a fact table are 2 different things. A fact is a measurement, which can be recorded. This fact is stored in a fact table. This enables you to analyse the measurement with its corresponding dimensions to gain the insights you need.