Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | baddulasStarting Member
 
 
                                        11 Posts | 
                                            
                                            |  Posted - 2014-03-29 : 06:58:51 
 |  
                                            | Hi all,Please help on the below scenario.Source - OracleTarget - SQL ServerAfter 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. |  |  
                                |  |  |  |