GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics

 Print  |  
Question:  What is Fact table

Answer:
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.


October 10, 2005 02:05:27 #5
 senthil kumar.B CRM Expert  Member Since: October 2005    Total Comments: 15 

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.

     

 

Back To Question