Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2009-07-10 04:23 AM

Truncate with ETL component

Hello,
I wanted to know if it is possible to truncate a table with ETL component.
Thanks.
Labels (2)
Labels
185 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2009-07-10 06:42 AM
Author

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"
185 Views
0 Likes