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, putproductlist_LUX_200909.txt
.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:
You re-ran the transformation you created in the previous tutorial, this time using a different input file. In this file, there were new products, some products were removed from the list, and some had their descriptions, categories, and prices modified.
When you ran the transformation for the second time, the new products were added to the table. Also, the modified prices of the products were updated. In the Step Metrics tab window...