my job will update the table my source and target is same table(SQL Server) and i also used the HASH keys
but i am getting the error message
and the job is aborted. if the same query i fired in MS-Access database it is working fine(it will only update the records with will not affect the uniquety constraint)Violation of UNIQUE KEY constraint 'IX_wk_PMGProvXref'. Cannot insert duplicate key in object 'wk_PMGProvXref'
The statement has been terminated.
how to bypass the constraint and update the records by using datastage job