Summary


In this chapter you learned what dimensions and dimension history are, and why you need to maintain dimension history. You learned the SCD (Slowly Changing Dimension) techniques and applied SCD1 and SCD2 to customer and product dimensions respectively.

In Chapter 7, “Initial Population” and Chapter 8, “Regular Population” you begin to include these techniques in your data warehouse initial and regular population, respectively. However, before that you need to learn an important characteristic of a fact table (measure additivity) in the next chapter



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