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:
    Time for action—testing the update of existing products
  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 was ...

Get Pentaho 3.2 Data Integration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.