Basics - What is Fact table

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 13 of 113

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.

Total Answers and Comments: 11

Last Update: March 08, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Meenal

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.

Above answer was rated as good by the following members:
nflow2, phdsong, mpgupta99

Sorting Options

Page 1 of 2

« First

Last »

June 05, 2005 11:36:27

deepak

RE: What is Fact table

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

Is this answer useful? Yes | No

1 2

Overall Rating: -1

June 24, 2005 01:06:32

etl-new

RE: What is Fact table

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

Is this answer useful? Yes | No

July 14, 2005 02:20:24

Meenal

RE: What is Fact table

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.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

October 04, 2005 02:05:27

senkumar79

Member Since: October 2005 Contribution: 17

RE: What is Fact table

Fact table contains the transactions data which have more columns and less no of rows.

Among the data it also includes the foreign key of the dimension tables which r attached to it.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

January 24, 2006 08:19:56

tapas

RE: What is Fact table

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

Is this answer useful? Yes | No

February 15, 2006 13:32:01

sangroover

RE: What is Fact table

Fact table will have numeric coloums.

Or Values of the coloumns in Dimension table

Is this answer useful? Yes | No

April 17, 2006 12:33:23

Kiran Cholleti

RE: What is Fact table

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

Is this answer useful? Yes | No

April 25, 2007 23:51:05

ramyagk

Member Since: April 2007 Contribution: 4

RE: What is Fact table

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.

Is this answer useful? Yes | No

May 07, 2007 14:55:39

chandrarekha

RE: What is Fact table

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

Is this answer useful? Yes | No

May 30, 2007 07:57:12

#10

sridhar

RE: What is Fact table

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Page 1 of 2

« First

Last »

Go To Top