topic Re: conditional table drop in Talend Studio

conditional table drop

pawe84 — Fri, 08 Jul 2022 06:46:47 GMT

Hi everyone,

how I can set up a conditional table drop.

For example:

If the current date equals January 1st all data of a table have to be deleted .

All other days data will only be inserted into the table.

Can I use tReplicate and two DBOutput?

Thanks for any advice.

Re: conditional table drop

Davis69 — Sat, 09 Jul 2022 06:20:35 GMT

WHERE clause mainly used along with the DELETE command. No clause required along with DROP command. Actions performed by DELETE can be rolled back as it uses buffer. Actions performed by DROP can't be rolled back because it directly works on actual data.

Re: conditional table drop

Anonymous — Mon, 11 Jul 2022 05:11:45 GMT

Hello,

With the action performed by DROP , you could use a select query in the same DB table to check whether the table can meet your condition and assign it to a context variable and then have an RunIf trigger from t<DB>Input where you can test the globalMap variable created to see if it's >0 and so trigger t<DB>Row to delete table if you want.

Best regards

Sabrina

Re: conditional table drop

Jfoster1657625676 — Wed, 27 Jul 2022 09:32:43 GMT

Thanks for sharing. It is clear for me