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.
02720825 (BOB member since 2019-09-09)