Home » Software Databases » Data Warehousing Databases » Data Warehousing Articles » The Factless Fact Tables

The Factless Fact Tables in Software Databases Directory

    

Over the past year I have given many examples of fact tables in dimensional data warehouses. You should recall that fact tables are the large tables in the middle of a dimensional schema. Fact tables always have a multipart key, in which each component of the key joins to a single dimension table. Fact tables contain the numeric, additive fields that are best thought of as the measurements of the business, measured at the intersection of all of the dimension values.

 


Website: http://www.dbmsmag.com/9609d05.html

Sponsored Links

Related Listings:

Apollo Total Store