Learning Pentaho Data Integration 8 CE - Third Edition

Loading a Type II SDC for the first time

In this tutorial, we will load the PUZZLE dimension for the first time. This is how we proceed:

1. Create a new Transformation.
2. Drag a Table input step to the work area and double-click on it.
3. As Connection, select js. In the SQL area, type the following query:

SELECT pro_code 
     , man_code 
     , pro_name 
     , pro_theme 
FROM  products 
WHERE pro_type LIKE 'PUZZLE%'

4. Click on OK.
5. Add an Add constants step and create a hop from the Table input step toward it.
6. Use the step to add a Date field named changedate. As format, type dd/MM/yyyy and as value, type 01/10/2017.
7. After the Add constants step, add a Dimension lookup/update step. You will find it in the Data Warehouse category of steps.
8. Double-click on the Dimension ...