What Is Fact Table?

1.	What Is Fact Table?
Answer» 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. 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.

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?