topic Re: Truncate Table then Insert in Talend Studio

Truncate Table then Insert

thomas_2583 — Fri, 15 Nov 2024 22:43:29 GMT

Hi,

I have the following process flow of which I need to tweak slightly if possible.

TDBInput ---> TMap ---> TDBOuput (Update and Insert).

Is there anyway that I can include somewhere within this job design to clear down (truncate) the table that is used within the

TDBOuput , and then insert the same table with the latest data?

Re: Truncate Table then Insert

gjeremy1617088143 — Wed, 20 Jul 2022 15:06:53 GMT

Hi @Steven Littlewood , on the tDBOutput you have a field named action on table, you can select truncate table in.

It will truncate the table before insert.

Re: Truncate Table then Insert

thomas_2583 — Wed, 20 Jul 2022 15:12:01 GMT

Hi @guenneguez jeremy That's brilliant, thank you for your help!

Re: Truncate Table then Insert

Jwoodberry — Wed, 03 Aug 2022 09:53:35 GMT

Does anyone know what i'm doing wrong here, I have a webpage that gets currency data from a remote source, I get the data and insert it into sql database via a stored procedure. If i put truncate in front of the insert statement, it truncates the table and inserts the last record. If i remove the truncate, it inserts all the records. MyAccountAccess Credit Card