Summary

In this chapter, you learned techniques to construct Transformations in different ways. First, you learned all about Kettle variables. By understanding how to define and use them, you can develop more flexible and reusable Transformations. After that, you created and used sub-transformations or mappings, another way to create reusable work. Then you were introduced to the mechanism of copying and getting rows, which you will revisit in the next chapters. Finally, you learned to iterate over transformations using the Transformation Executors.

There are still more possibilities to give power to your Transformations. One of them is about creating dynamic Extracting, Transforming, Loading (ETL) processes. You will learn about this in the next chapter.