Home Forums Data Warehousing Integration Services Update Data in Prod table. Lookup ? Merge? RE: Update Data in Prod table. Lookup ? Merge?
Tarun Jaggi
Hall of Fame
Points: 3365
More actions
March 11, 2013 at 5:25 am
#1595470
Can't you just truncate the target table and reload it again instead of checking whether the record exists or not?
This will give you a huge boost from the performance point-of-view.