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.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Stefan Graf

Data Engineer Consultant @Microsoft — Data and Cloud Enthusiast