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

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