| |
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. |
| May 05, 2007 07:57:12 |
#10 |
| sridhar |
Member Since: Visitor Total Comments: N/A |
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. |
| |
Back To Question | |
