topic Re: Logging Reject Record and Error Logging in Talend Studio

Logging Reject Record and Error Logging

Anonymous — Sat, 09 Jun 2012 04:21:08 GMT

Hi,
I am doing a one to one mapping and moving data from sql server(source) to oracle(target) using tMap. My requirement is that, I want to capture all the Reject records from my output table if any during the process and capture in a File. Also i need to capture oracle errors or other warnings into the same. Can you help me how i can do it in Talend?
Thanks
SUNDARESAN V

Re: Logging Reject Record and Error Logging

Anonymous — Mon, 11 Jun 2012 04:35:53 GMT

Hi SUNDARESAN V
Change the 'Action on data' into 'Insert or Update'.
Then right click on 'tOracleOutput'. You will find 'Row->Rejects' to capture reject rows.
Regards,
Pedro

Re: Logging Reject Record and Error Logging

Anonymous — Thu, 14 Jun 2012 05:45:30 GMT

Hi Pedra,
I am using talend 4.1.3 version . So here, as per your instruction i don't see an option of "ROW--> REJECTS" when i choose the action on data as "Insert or Update". Attaching the Screen shots of those. And when i use the reject records , it should not affect my commit interval by any cause. Can it be taken care also?

Thanks
SUNDARESAN V

Re: Logging Reject Record and Error Logging

Anonymous — Thu, 14 Jun 2012 05:58:34 GMT

Hi SUNDARESAN
You will see reject row as the following image.
Regards,
Pedro