Deleting records of a database table with the Delete step

The Delete step allows you to delete records of a database table based on a given condition. As shown following, the configuration window for the Delete step is really simple and very similar to the others explained previously:

The Delete step configuration window

Exactly as in the other windows explained, the upper section is where you define the database connection and the table involved.

Then, in the grid is where you define the conditions for the delete operation. The definitions you put in the grid represent the WHERE in a DELETE statement.

For each row that comes to the step, ...

Get Learning Pentaho Data Integration 8 CE - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.