What is a Fact table (and why you need them)
In the context of a data warehouse, a fact table represents a business process/event and contains the measures and metrics you want to analyze for that business process/event. There are three types of facts corresponding to three kinds of business events. A Fact doesn’t exist in isolation. It is related to a set of Dimensions….