Logging Reject Record and Error Logging

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads