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.
Press F9 to launch the transformation again.
As the value for the
PRODUCTLISTFILE
variable, insertproductlist_LUX_200909.txt
.Click Launch.
When the transformation ends, check the Step Metrics tab. You will see the following:
Switch to the SQL Query Browser application and click Execute to run the query again. This time you will see this:
You reran the transformation that was created in the previous tutorial, this time using a different input file. In this file there were new products and some products were removed from the list, whereas 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...