Monday, July 12, 2010

What is Fact and Fact table?

A Fact is a measurable value of the business for example Daily Sales, Headcount, etc.


A Fact Table contains the measurements or metrics or facts of business process. A fact table typically has two types of columns: those that contain facts and those that are foreign keys to dimension tables. The primary key of a fact table is usually a composite key that is made up of all of its foreign keys.

No comments:

Post a Comment


All Rights Reserved @ Raju Das