Pentaho Data Integration Beginner's Guide

Summary

In this chapter, you learned to transform your dataset by applying two magical steps: Row Normaliser and Row Denormaliser. These two steps aren't the kind of steps you use every day as for example a Filter Row or a Select values step. However, when you need to do the kind of task they can achieve, you are really grateful that these steps exist. They do a great task in a quite simple way. You also learned what a time dimension is and how to create a dataset for a time dimension.

Finally, you were introduced to the concept of Named Parameters.

So far, you have been learning how to transform data. In the next chapter, we will start learning to work with databases, a subject that most of you must be waiting for since the Installing MySQL section ...