O'Reilly logo

Pentaho 3.2 Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required