Pentaho Data Integration Beginner's Guide

Time for action – loading a region dimension with a Combination lookup/update step

In this tutorial, you will load a dimension that stores geographical information.

1. Launch Spoon and create a new transformation.
2. Drag a Table input step to the canvas and double-click on it.
3. As Connection, select js.
4. In the SQL area, type the following query and click on the OK button:

   SELECT ci.city_id, city_name, country_name
   FROM cities ci, countries co
   WHERE ci.cou_id = co.cou_id

5. Expand the Data Warehouse category of steps.
6. Select the Combination lookup/update step and drag it to the canvas.
7. Create a hop from the Table input step to this new step.
8. Double-click on the Combination lookup/update step.
9. As Connection, select dw.
10. As Target table browse and select lk_regions