One Star

Truncate with ETL component

Hello,
I wanted to know if it is possible to truncate a table with ETL component.
Thanks.
1 REPLY
Four Stars

Re: Truncate with ETL component

Hello,
Yes it's possible, you have two ways:
- Before insert data with talend, on tXXOutput component, select "TRUNCATE" for "Action on table".
- With a tXXRow, give your sql statement, like "TRUNCATE TABLE Customers"