Logging Reject Record and Error Logging

Highlighted
One Star

Logging Reject Record and Error Logging

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
One Star

Re: Logging Reject Record and Error Logging

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
One Star

Re: Logging Reject Record and Error Logging

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
One Star

Re: Logging Reject Record and Error Logging

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now