O'Reilly logo

Pentaho 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, 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:
    Time for action – testing the update of existing products
  6. Switch to Squirrel and re-run the query. This time you will see the following:
    Time for action – testing the update of existing products

What ...

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