| |
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. |
| July 07, 2005 02:20:24 |
#4 |
| Meenal |
Member Since: Visitor Total Comments: N/A |
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. |
| |
Back To Question | |
