|
Fact table - Definition and Overview |
| Related Words: Album, Ambo, Annals, Annual, Bar, Basin, Bench, Blotter, Blueprint, Board, Bread |
|
|
|
A fact table is a data warehousing concept. It consists of the measurements, metrics or facts of a business process. It is often located at the centre of a star schema, surrounded by dimension tables.
Example
Now if the business process is say SALES, then the fact table will typically contain values representing both raw facts and aggregations such as:
- $12,000, being "sales for New York store for 15-Jan-2005"
- $34,000, being "sales for Los Angeles store for 15-Jan-2005"
- $22,000, being "sales for New York store for 15-Jan-2005"
- $40,000, being "sales for Los Angeles store for 16-Jan-2005"
- $21,000, being "average daily sales for Los Angeles Store for Jan-2005"
- $35,000, being "average daily sales for Los Angeles Store for Feb-2005"
- $33,000, being "average daily sales for Los Angeles Store for year 2005"
"average monthly sales" is a measurement which is stored in the fact table. The fact table also contains foreign keys from the dimension tables, where time series (e.g. dates) and other dimensions (e.g. store location, salesman, product) are stored.
| It is requested this article be expanded. Please improve it according to its listing on Wikipedia:Requests for expansion, or in any other way that you see fit. Once the requested improvements have been completed, you may remove this notice and the page's listing.
|
|
|
Example Usage of table |
 |
5PMPoker: original won 2336 chips with Four Aces on table 24. |
 |
smethportpa: 12/14/09 -- Smethport resident Matt Muller in Chenzhou, China says it's okay there to spit out your food on the table if you don't like it! |
 |
TheRealJayDee: RT:@DamienDW: FELLAS..If all she does is look cute & complain while u bust ur ass 2 pay da bills & keep food on the table #thatsthatbullshit |
|
