In dimensional data warehousing, the word “Fact” in means a measure, i.e. a single numeric column.
The word “Fact Table” means a database table or view that contains the Fact or Measure columns.
Above are what Ralph Kimball and Margy Ross used in their Toolkit book (link).
Lately, I heard people use the word “Fact” to refer to a fact table. For example “A fact has measures”. I’m not saying it’s wrong, as people can term it as they like. I’m saying that it is not standard. I put a post here so that the community is not surprised when you heard the word “Fact” used in that way.
Advertisement
