Interview Questions

What is Fact table?

Data Warehousing Interview Questions and Answers


(Continued from previous question...)

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.

(Continued on next question...)

Other Interview Questions