Hi all,
I am using UPDATE_INSERT in the mapping for the receiver JDBC scenario.
As name says, update and insert should be done. Updates for any row that has been changed, else the new rows should be inserted.
The problem that I am having is - say I insert 4 rows. Then I change 1 of the rows in the source system and re-send those 4 rows again (3 old and 1 changed). So, it should only update the 1 changed row and nothing else should happen.
But it is over-writing the all the 4 records with the 1st record (I changed the values in the 2nd row). So, 4 rows are there after the 2nd run, but all the rows are having the same value as the 1st row.
I am following the structure prescribed in SAP document and using a Key field.
Where I am doing wrong? Any suggestions will be highly appreciated.
Thanks,
Abhi