fact table

English - English

Definition of fact table in English English dictionary

A table in a star schema that contains facts A fact table typically has two types of columns: those that contain facts and those that are foreign keys to dimension tables The primary key of a fact table is usually a composite key that is made up of all of its foreign keys A fact table might contain either detail level facts or facts that have been aggregated (fact tables that contain aggregated facts are often instead called summary tables) A fact table usually contains facts with the same level of aggregation (See also dimension table )

A table, typically in a data warehouse, that contains the primary data

(Data Warehousing Guide)

(Data Warehousing Guide; search in this book)

(Clickstream Intelligence Administrator's Guide) [definition #2] (Clickstream Intelligence User's Guide)

In the central table which contains the individual facts being stored in the database

Hyphenation

fact ta·ble

Turkish pronunciation

fäkt teybıl

Pronunciation

/ˈfakt ˈtābəl/ /ˈfækt ˈteɪbəl/