Nesting transformations and jobs

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):

  1. Create a new job.
  2. Drag one START entry and two Transformation job entries to the work area, and link them ...

Get Pentaho Data Integration Quick Start Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.