Pentaho 3.2 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, please open it.
2. Press F9 to launch the transformation again.
3. As the value for the PRODUCTLISTFILE variable, insert productlist_LUX_200909.txt.
4. Click Launch.
5. When the transformation ends, check the Step Metrics tab. You will see the following:
   
6. Switch to the SQL Query Browser application and click Execute to run the query again. This time you will see this:

What just happened?

You reran the transformation that ...