Facts Vs Dimensions Tables In A Database
Facts and dimensions form the core of any business intelligence effort. These tables contain the basic data used to conduct detailed analyses and derive business value. This article takes a look at the development and use of facts and dimensions in a database. What Are Facts and Fact Tables? Fact tables contain the data corresponding to a particular business process. Each row represents a single event associated with a process and contains the measurement data associated with that event....