Update or Insert from excel to mysql database

[Anonymous]

Hi.. I am newbie in talend.

I am trying to migrate data from table to another table in the same database. Task that I need to do :

1) Update - if ic_no(in pesara) is exist

2) Insert new row - if ic_no is not exist

I've already set the action dataout for update and dataInsert for only insert new row. I am not sure if my tMap setting is correct.

Total of data that need to migrate is 150k, and total for current output databse is 240k.. I am not sure if the amount of data effect the job. I appreciate if someone can help me on this.

Thank you in advance

[Anonymous]

https://www.rilhia.com/tutorials/using-auto-generated-primary-key-update-row-just-inserted-mysql-dat...