In the example developed in the previous section, you executed a transformation from a job. In the same way, you can execute a job from a job. The subjob, or inner job (that is, the job called by the main job), can also execute one or several subjobs or transformations, and so forth. To see a practical example of this, let's create a main job that loads the sample datamart by executing the different jobs and transformations that we have created so far.
First, let's create a job that loads all of the dimensions (with the exception of the TIME dimension, which is usually created once and never updated):
- Create a new job.
- Drag one START entry and two Transformation job entries to the work area, and link them ...