02720825 Forum Member


Joined: 09 Sep 2019
Posts: 1

|
Posted: Mon Sep 09, 2019 3:48 am Post subject: how to optimize insert update delete? |
|
|
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. |
|