topic Empty Tables in Talend Studio

Empty Tables

Anonymous — Tue, 15 Oct 2013 15:30:19 GMT

Hi all,
i am trying to create a job, that delete all rows in my tables and make them empty.
Any suggestion how?
Thanks

Re: Empty Tables

Anonymous — Tue, 15 Oct 2013 15:56:27 GMT

Here are two simple methods:
Use a tOracleRow component. In the query, type "Delete from tablename where 1 = 1". Do this for each table you want to clear.
Use a tOracleOutput component. In the dropdown for "Action on table", select "Clear Table". This will delete all data in the table before inserting the new data.
Although I am referring to tOracle components, the same function is available for other databases. Just use the right component for the database you are working with.

Re: Empty Tables

Anonymous — Tue, 15 Oct 2013 16:03:12 GMT

I used tOracleRow and it works.
Thanks !