Summary

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

First, you learned all about the different scopes for variables. You saw how to define named parameters in jobs, and also learned how to supply parameters from a parent Job to sub-jobs and transformations. Besides, you saw several ways to get a smart use of Kettle variables so that your work looks cleaner and more organized.

Then, you were presented new ways to use the copied rows. In this opportunity, you used them to manage files in advanced ways, and also as parameters of jobs and transformations.

After this, you learned what result filelists are, how to create and modify them, and of course, how to use them for different purposes such as zipping files or attaching files to an email.

Finally, you learned how to nest jobs and iterate the execution of jobs.

You already have all the knowledge to develop both simple and complex ETL processes. You are now ready for the next chapter, where you will see in detail how to launch transformations and jobs from the command line.