What is a Fact Table?

A fact table is also a Table in the database contains Facts (Measures such as quantity sold, revenue, and account balance) and foreign keys. (These keys will be used to connect to various dimension tables such as Product, Time, Customer, Staff to get information like product name, staff name, customer name etc…)
Take a look at the following Image.. The yellow shaded columns are fact columns and the remaining columns are key columns, which will be used to connect to dimension tables..