DATA TRUNCATION ISSUE IN TARGET DATA BASE Hi all, Please help on the below scenario.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • baddulas
    New Member
    • Mar 2014
    • 1

    DATA TRUNCATION ISSUE IN TARGET DATA BASE Hi all, Please help on the below scenario.

    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.
Working...