List of Tables


Chapter 1: Basic Components

Table 1.1: A sample row from the fact table
Table 1.2: The related row in the customer dim table
Table 1.3: The related row in the product_dim table
Table 1.4: The related row in the date dim table
Table 1.5: The related row in the order_dim table

Chapter 2: Dimension History

Table 2.1: The customer_dim table before changes are applied
Table 2.2: The revised customer details

Chapter 7: Initial Population

Table 7.1: Your data warehouse’s data sources

Chapter 8: Regular Population

Table 8.1: Data sources and loading types of regular population

Chapter 15: Dimension Hierarchies

Table 15.1: Hierarchies in customer_dim, product_dim, and date_dim

Chapter 16: Multi-Path and Ragged Hierarchies

Table 16.1: 2005 Campaign Sessions

Chapter 24: Accumulated Measures

Table 24.1: Month end balance prepared data

Chapter 25: Band Dimensions

Table 25.1: Marketing segment bands

Appendix A: Flat File Data Sources

Table B.1: Flat files data sources and usage instructions



Dimensional Data Warehousing with MySQL. A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149

Similar book on Amazon
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Successful Business Intelligence: Secrets to Making BI a Killer App

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net