I have 2 same parallel job where read one table from DB2 iseries
and over stage "copy" load data to some Netezza tables.
One job run succesful. Another fail with message
S01_EMPL_51: Failed to execute SQL statement: UPDATE S01_EMPL t SET t.DPTCOD=s.DPTCOD, t.EMPBEG=s.EMPBEG, t.EMPEND=s.EMPEND, t.EMPFAM=s.EMPFAM, t.EMPNAM=s.EMPNAM, t.EMPPTR=s.EMPPTR, t.DPTCOD_WRK=s.DPTCOD_WRK FROM NZCC_TT_20130808135305648S01_EMPL AS s WHERE t.EMPNMB=s.EMPNMB. Reason: [SQLCODE=HY000][Native=46] ERROR: Update canceled: attempt to update a target row with values from multiple join rows
Properties for target tables are identical in this jobs.
Error with Upsert to Netteza connector IIS-CONN-NZ-01004
Moderators: chulett, rschirm, roy