Truncate tables


This job entry allows you to truncate one or several tables at once without writing 0 SQL command.

(warning) Important: Just like all steps in the "Experimental" category, this step is not considered ready for production use by the author. In the specific case of this job entry we lacked the time to do extensive testing on it. Your feedback is most welcome as always.






Job entry name

It's the name of the job entry in the job. 

Note: This name has to be unique in a single transformation.


Name of the database connection on which the tables reside. Use "Edit..." and "New..." to edit and/or create a new connection.

Previous results to args?

check this option if you want to get in a dynamic way tables to truncate from results of previous job entry.

Note: The first field have to be the table name and the second one the schema (leave it Null if it's not needed).

Click here to return tables name list

This button will return all tables defined on the connection. Select tables (one or several) and press "OK". Tables name will be automatically added to "Selected tables" grid.

Selected tables grid

Specify here the tables to truncate (insert it manually or use the previous button). If the table is in a different schema that the default one, please specify the schema name.


Remove entries from grid (select one several entries and click on this button to remove it).


Click on this button to save job entry settings changes


Discard job entry settings changes


How to use

Expand "Experimental" in the Desing section (left panel) and select "Truncate tables" job entry. Move it to the workspace. You can use this job entry just after a "STAR" entry point or between two others job entries.


If this job entry truncates successfully all tables it return TRUE otherwhise FALSE. Yo can test 3 kinds of result (the execution went successfully (GREEN), Somthing went wrong (RED), unconditional (BLACK).