GeekInterview.com
Series: Subject: Topic:
Question: 121 of 133

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.
Asked by: Interview Candidate | Asked on: Jul 14th, 2005
Showing Answers 1 - 13 of 13 Answers
deepak

Answered On : Jun 5th, 2005

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

Yes  2 Users have rated as useful.
  
Login to rate this answer.
etl-new

Answered On : Jun 24th, 2005

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

Yes  2 Users have rated as useful.
  
Login to rate this answer.
Meenal

Answered On : 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.

Yes  4 Users have rated as useful.
  
Login to rate this answer.

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.

  
Login to rate this answer.
tapas

Answered On : 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.

  
Login to rate this answer.
sangroover

Answered On : Feb 15th, 2006

Fact table will have numeric coloums.Or Values of the coloumns in Dimension table

  
Login to rate this answer.
Kiran Cholleti

Answered On : 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 mekiran cholleti

  
Login to rate this answer.
ramyagk

Answered On : Apr 25th, 2007

View all answers by ramyagk

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.

  
Login to rate this answer.
chandrarekha

Answered On : May 7th, 2007

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

  
Login to rate this answer.
sridhar

Answered On : 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.

Yes  2 Users have rated as useful.
  
Login to rate this answer.
ibrarx

Answered On : Mar 7th, 2009

View all answers by ibrarx

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.

  
Login to rate this answer.

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

  
Login to rate this answer.
munavar.shaik

Answered On : Jan 20th, 2011

View all answers by munavar.shaik

A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts tableA dimension table is the entity describing the textual representation of the business. Eg: Customer table,Customer Address Table,Product table,Time dimension tableIn 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 clarifiesMunavar Shaik

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.