Pentaho Data Integration Beginner's Guide

Time for action – testing the update of existing products

In the preceding tutorial, you used an Insert/Update step but only inserted records. Let's try the transformation again to see how the update option works.

1. If you closed the transformation, open it.
2. Press F9 to launch the transformation again.
3. As the value for the PRODUCTLISTFILE variable, put productlist_LUX_200909.txt.
4. Click on Launch.
5. When the transformation ends, check Step Metrics. You will see the following:
   
6. Switch to Squirrel and re-run the query. This time you will see the following:
   

What ...