https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330991#M100018 <P>I'm loading data to Netezza using tNetezzaBulkExec but it always fails because it reaches the max number of errors.</P> <P>Is there anyways to capture the rows that error out?</P> Wed, 16 May 2018 20:28:40 GMT Anonymous 2018-05-16T20:28:40Z https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330991#M100018 <P>I'm loading data to Netezza using tNetezzaBulkExec but it always fails because it reaches the max number of errors.</P> <P>Is there anyways to capture the rows that error out?</P> Wed, 16 May 2018 20:28:40 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330991#M100018 Anonymous 2018-05-16T20:28:40Z https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330992#M100019 <P>Hello,</P> <P>Are you able to use tNetezzaOutput component to load data to Netezza successfully?</P> <P>Here is a "Rejects" link from tNetezzaOutput component which allows you to track the data that could not be processed for any reason (wrong type, undefined null value, etc.)</P> <P>Best regards</P> <P>Sabrina</P> Mon, 21 May 2018 05:20:12 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330992#M100019 Anonymous 2018-05-21T05:20:12Z https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330993#M100020 <P>Thank xdshi for your reply. Unfortunately I don'tt use tNetezzaOutput&nbsp;because it is very, very&nbsp;slow and I have about 63 million records to load.</P> <P>If that is the only option, I guess I will be forced to split the file and try.</P> <P>Thank again&nbsp;&nbsp;&nbsp;&nbsp;</P> Mon, 21 May 2018 15:18:07 GMT https://community.qlik.com/t5/Talend-Studio/How-to-get-rejected-records-by-tNetezzaBulkExec/m-p/2330993#M100020 Anonymous 2018-05-21T15:18:07Z