deepak

• Jun 5th, 2005

 

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

etl-new

• Jun 24th, 2005

 

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

Meenal

• 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.

senkumar79

 Profile Answers by senkumar79 Questions by senkumar79

• Oct 4th, 2005

 

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.

tapas

• 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.

sangroover

• Feb 15th, 2006

 

Fact table will have numeric coloums.

Or Values of the coloumns in Dimension table

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

ramyagk

 Profile Answers by ramyagk 

• 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.

chandrarekha

• May 7th, 2007

 

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

sridhar

• 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.

ibrarx

 Profile Answers by ibrarx 

• 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.

ashwinijawalgekar

 Profile Answers by ashwinijawalgekar 

• Jun 9th, 2010

 

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.

munavar.shaik

 Profile Answers by munavar.shaik 

• Jan 20th, 2011

 

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