Pentaho Data Integration Beginner's Guide

Time for action – loading the SALES star

You already created a job for loading the dimensions and another job for loading the fact.

In this section, you will put them together in a single main job:

1. Create a new job in the same folder in which you saved the mentioned jobs. Name this job load_dm_sales.kjb.
2. Drag to the canvas a START and two Job job entries, and link them one after the other.
3. Use the first job entry to execute the job that loads the dimensions.
4. Use the second job entry to execute the job you just created for loading the fact table.
5. Save the job. This is how it looks:
   
6. Press F9 to run the job.
7. As arguments, provide a new range of dates: 2009-09-01 ...