You already know a lot about Kettle variables. This time, you will learn how those variables can help you create more flexible and reusable work.
Before explaining the different ways in which variables can be used to enhance your processes, it's important to introduce the concept of nested jobs, which is closely related to the scope of variables.
In the same way that you can run a Transformation inside a Job, you can also run a Job from a Job, which allows you to nest the execution of jobs. In order to do this, you use the Job
Job entry, located in the General
category of job entries. A Job with nested jobs will look like this:
Nested jobs
Just like any job entry, the Job Job entry may end successfully or may fail. Based on this result, PDI decides which of the entries that follow it will execute. None of the entries following the
Job
Job entry start until the nested Job ends its execution.
You nest jobs mainly for organization...