AnsweredAssumed Answered

Database Dynamic Delete

Question asked by spaduri906455 on Sep 16, 2018
Latest reply on Sep 18, 2018 by trey.yeager826393

Hello all,


I have got a requirement to delete the records in target table Salesorder Line(Oracle DB) which were deleted in Source Table(Netsuite). (Key - InternalID and Line)

I have developed a process to update/insert the records into DB from Netsuite using Standard Statement. I have tried including delete in Merge statement by comparing InternalId and Line but never succeeded.  So trying to develop a separate process for delete.


1)Records in Database to be deleted whenever it gets deleted in Netsuite

2)Comparison Keys- InternalID and Line



Any ideas on how to develop will be helpful.


Thanks in Advance.