talend - lost few records not inserted in database

Question

I am very new to talend and I have been struggling with this since two weeks now

I need to diagnose a problem happening with a job (see picture)

When I execute the job I see on the screen it says 1000 rows committed to the database but when you go to the database there is fewer records

Is there a way to tell why there are fewer records committed to the database then what it said on the screen ?

tmap:

Answer 1

After talking to a few colleagues, I got some interesting answers. About your question, you could add a reject link after tMysqlOutput to see if it has any records.

For example: tMysqlInput--main--tMap--out1--tMysqlOutput---reject--tLogRow

Hope this helps! T Data.