Categories
Miscellaneous

Factless Fact Tables

DBMS – September 1996 – Data Warehouse Architect
Over the past year I have given many examples of fact tables in dimensional data warehouses. You should recall that fact tables are the large tables “in the middle” of a dimensional schema. Fact tables always have a multipart key, in which each component of the key joins to a single dimension table. Fact tables contain the numeric, additive fields that are best thought of as the measurements of the business, measured at the intersection of all of the dimension values.