How to get rejected records by tNetezzaBulkExec

Four Stars

How to get rejected records by tNetezzaBulkExec

I'm loading data to Netezza using tNetezzaBulkExec but it always fails because it reaches the max number of errors.

Is there anyways to capture the rows that error out?

Moderator

Re: How to get rejected records by tNetezzaBulkExec

Hello,

Are you able to use tNetezzaOutput component to load data to Netezza successfully?

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.)

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: How to get rejected records by tNetezzaBulkExec

Thank xdshi for your reply. Unfortunately I don'tt use tNetezzaOutput because it is very, very slow and I have about 63 million records to load.

If that is the only option, I guess I will be forced to split the file and try.

Thank again