A type of table in the dimensional model. A fact table typically includes two types of columns: fact columns and foreign keys to the dimensions.
The main table of a “star†database schema that has a composite key composed of attributes that are foreign keys for several dimension tables.
The central table in a star join schema, characterized by a composite key, each of whose elements is a foreign key drawn from a dimension table. Facts are information about the business, typically numeric and additive. A table that contains the measures that the business users wish to analyze to find new trends or to understand the success or failure of the organization.
a collection of facts and foriegn key relations to the dimensions
a data warehousing concept
a table that contains different kinds of data in the same physical structure
a table that contains summarized numerical and historical data (facts) and a multipart index composed of foreign keys from the primary keys of related dimension tables
a table that contains the measures of interest
A table, or in many cases a set of four tables, that DB2 OLAP Server creates in your relational database that contains all data values for a relational cube.
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.
A discrete item of business information. In fact/qualifier modeling, this term describes a role in which business data may be used. The alternative is to be used as a qualifier. Facts are typed as descriptive or metric. When developing star and snowflake schema, the set of facts is constrained to those metric facts that represent the business measures that are the focus of a particular data mart.
A central table in a data warehouse schema that contains numerical measures and keys relating facts to dimension tables. Fact tables contain data that describes specific events within a business, such as bank transactions or product sales.
Usually the primary table that contains measurements (mostly numeric data like grade, wages, etc.). Also see dimension table. Imagine looking at a spreadsheet. The row and column names would be the dimensions and the numeric data within would be the facts.
The tables which are extracted from heterogeneous sources and used in the Data Wareahouse
table, typically in a data warehouse, that contains the measures and facts (the primary data). Also see Dimension Table.
A central table in a data warehouse schema that contains numerical measures and keys relating facts to dimension tables. Fact tables contain data that describes specific items, such as project IDs and names within a project's dimension or BCWP for a specified date in a task.
In data warehousing, a fact table consists of the measurements, metrics or facts of a business process. It is often located at the centre of a star schema, surrounded by dimension tables.