fact table

Englisch - Englisch

Definition von fact table im Englisch Englisch wörterbuch: 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