Hello,everyone. When you load data into the database using Jdbc Writer and execute the plan every time, it keeps adding the same data from above. How can I overwrite the data? For instance, I have a table like this.
I saved it in the database, made some changes to the table, and when I re-executed the plan, it added the changes on top. Duplicates appeared, to put it bluntly.I will be very grateful for your help Thank you!
Best answer by Albert de Ruiter
Hi
Kind regards, Albert
+4Hi,
If the target table always needs to reflect the source table, wouldn't it be most straightforward to truncate the target tabe first before loading?
Or is your requirement more complex?
Kind regards,
Albert
Hi
I have a plan, it immediately pours the result into the database. Do you know how to first truncate the target table before uploading to Atacama Desktop?
Kind regards,
Assel
+4Hi
Kind regards, Albert
Thanks for the idea, I used the SQL Execute step, simplified my task
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
