In real projects, you don't run isolated transformations or jobs. Instead, you combine their execution, in order to create a flow of tasks. In particular, you can run jobs or transformations from a job, and you can also iterate the execution of transformations and jobs by simulating a loop. In this section, you will learn how to implement some of these combinations. The sample jobs and transformations will be related to the datamart introduced in Chapter 5, Loading Data.
Combining the execution of jobs and transformations
Executing transformations from a job
To demonstrate how to execute a transformation from a job, we will create a job with the following purpose: it will find out the maximum date in the injuries fact...