I am trying to load DB2 table in Upsert method. Updates are happening first and then Inserts. I am getting the error
INDEX1 RESTRICTS COLUMNS WITH SAME VALUES. TABLE NAME
But if it is Update Then Insert then why is this issue happening?
Even if there are duplicates in my source, the problem should happen only if the Option selected was Insert Then Update or Insert Only
Is it possible the input data has duplicate rows. Therefore there are two copies of the same primary keys. Both are tried to be updated and fail, so both become inserts?
I know strictly speaking you may not expect this to happen.