Talend community forum / Logging Reject Record and Error Logging

sundaresanv · 2012-06-09 05:21:08

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

pedro · 2012-06-11 05:35:53

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

sundaresanv · 2012-06-14 06:45:30

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

Uploaded Images

pedro · 2012-06-14 06:58:34

Hi SUNDARESAN

You will see reject row as the following image.

Regards,
Pedro

Uploaded Images

Announcement

Unanswered posts

#1 2012-06-09 05:21:08

Logging Reject Record and Error Logging

#2 2012-06-11 05:35:53

Re: Logging Reject Record and Error Logging

#3 2012-06-14 06:45:30

Re: Logging Reject Record and Error Logging

#4 2012-06-14 06:58:34

Re: Logging Reject Record and Error Logging

Board footer