Summary

In this chapter, you learned techniques to combine jobs and transformations in different ways.

First, you learned to isolate part of a transformation as a subtransformation. You also learned to implement process flows by copying and getting rows.

Then, you learned to nest jobs and to iterate the execution of jobs and transformations.

Finally, you learned to define your own variables at runtime. You defined variables in one transformation and then used them in other jobs and/or transformations. You also learned to define different scopes for those variables.

By using all these PDI capabilities, your work will look cleaner and will be more organized.

Let's say that this was a really productive chapter. By now, you should feel that you are ready to use PDI for developing most of your requirements. And you are indeed.

You are now ready for the next chapter, where you will develop the final project that will allow you to review a little of everything you have learned throughout the book...