how to optimize insert update delete?

02720825 · Forum Member Joined: 09 Sep 2019 Posts: 1

Hello,

in my scenario, i want to insert data in target if source having new record,
update target table whenever source record is updated, and delete from target when record deleted from source. also i want to optimize this because we have 306 billion record which takes more than 4 hrs.

i used table comparison with map operation as normal-normal, insert-insert, update-update. delete-delete.
i have required same records which available in source. but in my scenario i have not getting desired output.

please guide
and
thanks in advanced.