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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

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