Fact Table Article Index for
Fact 		Website Links For
Table 		 

Information About

Fact Table
  CATEGORIES ABOUT FACT TABLE
   
data warehousing
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...




EXAMPLE

If the Business Process is SALES, then the corresponding Fact Table will typically contain values representing both Raw Fact s and Aggregation s 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 16-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 Key s from the Dimension Table s, where Time Series (e.g. dates) and other Dimensions (e.g. store location, salesman, product) are stored.