Delete from DB based on condition

[Anonymous]

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

[manodwhb · Accepted solution]

@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.