Chapter 7. Transforming the Rowset
There are occasions when your dataset does not have the structure you like or the structure you need. The solution is not always about changing or adding fields, or about filtering or adding rows. The solution has to do with pivoting the whole dataset.
In this chapter, you will learn:
- Conversion of rows to columns, also called denormalizing
- Conversion of columns to rows, also called normalizing
- You will also be introduced to a core subject in data warehousing, called time dimensions
