Dimensional Data Warehousing with MySQL: A Tutorial

In this chapter you learned the multi-path hierarchy and ragged hierarchy. You also applied drilling queries to test the multi-path hierarchy in the month dimension.

In Chapter 17, “Degenerate Dimensions” you will learn a technique called degenerate dimension, which you can use to simplify a dimensional schema.