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.
- If you closed the transformation, open it.
- Press F9 to launch the transformation again.
- As the value for the
PRODUCTLISTFILE variable, put
- Click on Launch.
- When the transformation ends, check Step Metrics. You will see the following:
- Switch to Squirrel and re-run the query. This time you will see the following: