Time for action – deleting data about discontinued items

Suppose a manufacturer informs you about the categories of products that will no longer be available. You don't want to have in your database products something that you will not sell. Then you use PDI to delete them.

1. From the Packt website, download the LUX_discontinued.txt file.

2. Create a new transformation.

3. With a Text file input step, read the file.

4. Preview the file. You will see the following:

   

5. After the Text file input step, add an Add constants step to add a String constant named man_code with value LUX.

6. Expand the Output category of steps and drag a Delete step to the canvas.

7. Create a hop from the Add constants step to the Delete step.

8. Double-click the Delete step. Select js as Connection and, as Target table, browse and select products. In the grid add the conditions man_code = man_code and pro_theme LIKE category. After the Delete step, add a Write to log step.

9. Right-click the Delete step and define the error handling just like you...