What is Fact table

Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.

Showing Answers 1 - 13 of 13 Answers


  • Jun 5th, 2005

A fact table in dataware house is it describes the transaction data.It contains characterstics and keyfigures.


  • Jun 24th, 2005

A Fact table is a collection of facts and foriegn key relations to the dimensions.


  • Jul 14th, 2005

Fact Table contains the measurements or metrics or facts of business process. If your business process is "Sales" , then a measurement of this business process such as "monthly sales number" is captured in the Fact table. Fact table also contains the foriegn keys for the dimension tables.


  • Jan 24th, 2006

Fact Table contains the keys(primary key,foreign key) of the releated dimension tables and measures which is based on the keys.

  Was this answer useful?  Yes


  • Feb 15th, 2006

Fact table will have numeric coloums.

Or Values of the coloumns in Dimension table

  Was this answer useful?  Yes

Kiran Cholleti

  • Apr 17th, 2006

fact table which represents the information of measurments and aswell as the foreign key of dimention table.... if am wrong please inform me

kiran cholleti

  Was this answer useful?  Yes


  • Apr 25th, 2007

Its a table which contains only measures like total,distance,Fare,Number of parcels,Weight etc.
     It contains only numeric values and contains foreign keys.

  Was this answer useful?  Yes


  • May 7th, 2007

A Fact table contains a composite key where each candidate key is the foreign key of the dimension table

  Was this answer useful?  Yes


  • May 30th, 2007

Fact table is the one which contains measures of interest at most granular level.These values are numeric.Ex:sales amount would be a measure .

Each dimension table has a single-part primary which exactly corresponds to one of the components of  multiparty key in fact table.

The Dimension table provides detailed info about the facts.eg:quarter,year corresponding to sales amount would be part of dimension table.


  • Mar 7th, 2009

A fact table in a data warehouse is one which contains the numeric data, can be further distributed as 'Additive Facts' and 'Non-Additive Facts'.
Additive facts can be the sum of salaries.
Non-Additive facts can be something containing the averages.

most importantly it contains a multiple-part key, composed of the primary keys of the dimension table.

  Was this answer useful?  Yes

Fact  table is a normalized table divided in to 2 parts 

  1. Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension tables.
  2. Evaluated facts from linked tables -> Second part of fact table contains the summerised set of aggrigated values which helps management in decision making process.

  Was this answer useful?  Yes

A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts table

A dimension table is the entity describing the textual representation of the business.
Eg: Customer table,Customer Address Table,Product table,Time dimension table

In a banking model the account and balances are the measurements with in the fact table where as customer name,social security address, time period of the account are the dimensions (customer/time).

Hope it clarifies

Munavar Shaik

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions