Delete from DB based on condition

Anonymous — Wed, 14 Nov 2018 09:42:26 GMT

Hi,

I need to load an excel file to DB based on Batch_Id , but before doing so , I need to check if the Batch_id is already present in the DB or not. If present , data must be deleted from the DB and load , if not present , simply load. Is there a way to delete and load ?

Thanks,

Suman

Re: Delete from DB based on condition

manodwhb — Wed, 14 Nov 2018 10:10:20 GMT

@Skp22,you need to spit the two different flow and by doing left outer join in tMap or tJoin. one for delete and another one for insert.

topic Delete from DB based on condition in Talend Studio

Delete from DB based on condition

Re: Delete from DB based on condition