The Definitive Guide to Data Quality
2. Setting up a "unique" field in the database and using tMySqlOutpout insert/ignore. I figured that the database would nicely just fail and move on to the next record. Talend does not do that, it simply stops inserting records, like it tries them all and does not commit changes, or it simply stops trying. (or at least that's what I think it does, again, no SQL transaction log for me to check, and I can't find a way to troubleshoot my queries.)
Please assist. It's a simple problem, don't insert a record if it is already there.
And this job is so high priority and due yesterday it is scary.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to enable Data Governance
Take a peek at the definitive guide to Government Data Quality