I have a job whereby an insert into a non-transactional table throws up duplicate key errors. Clearly, I can handle this with a dedupe of the data before it is loaded but where this does occur I'd like an exception / warning to be thrown and captured so that I can have a message sent to our log server to flag a violation has occured. At the moment it has been silently failing.
What database are you using and which Talend component to access it? Can you show a screenshot of your job and the details of the database component? Thanks.
