Basics - What is Fact table

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 13 of 111

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: May 30, 2007

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

Sorting Options

Page 1 of 2

« First

Last »

May 22, 2005 18:46:03

Chintan

RE: What is Fact table

A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.

Is this answer useful? Yes | No

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

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

1 0

Overall Rating: +1

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

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

#10

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

Page 1 of 2

« First

Last »

Go To Top