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.