What is Fact table?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(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 Job Interview Questions

• What is hybrid slowly changing dimension?
• What is a CUBE in datawarehousing concept?
• What is Fact table?
• What are Data Marts?
• What is the difference between Datawarehousing and BusinessIntelligence?
• What is aggregate table and aggregate fact table ... any examples of both?
• Differences between star and snowflake schemas?
• What is the difference between datawarehouse and BI?
• Why is Data Modeling Important?
• Why should you put your data warehouse on a different system than your OLTP system?
• More...