Hi all,
Please help on the below scenario.
Source - Oracle
Target - SQL Server
After every 2 hours data is truncating from target and loading the source data.Now i don't want to lose the target data.only matched records needs to be delete from target.
Which approach is best for the above scenario.
Please help on the below scenario.
Source - Oracle
Target - SQL Server
After every 2 hours data is truncating from target and loading the source data.Now i don't want to lose the target data.only matched records needs to be delete from target.
Which approach is best for the above scenario.