topic Re: How to Capture reject records from DBOutput with Batch node on? in Talend Studio

How to Capture reject records from DBOutput with Batch node on?

Anonymous — Sat, 16 Nov 2024 02:15:24 GMT

Hi,

I am having a flow from source to DB Target. We have setup the batch and parallel mode on for the performance. however now the DBOutput does not allow to have rejected rows mapping.

How can I capture the rejected rows from this DB Output?

Thanks in advance for your help.

Re: How to Capture reject records from DBOutput with Batch node on?

manodwhb — Wed, 03 Jun 2020 12:41:42 GMT

@azshaikh , can you show your job design?

Re: How to Capture reject records from DBOutput with Batch node on?

Anonymous — Wed, 03 Jun 2020 13:19:30 GMT

Here it is,

Re: How to Capture reject records from DBOutput with Batch node on?

manodwhb — Wed, 03 Jun 2020 13:28:04 GMT

@azshaikh , that option is not there when you use parallel execution ,since you need to check manually the rejected line before load into DB like coulmn is null then otherflow.

Re: How to Capture reject records from DBOutput with Batch node on?

Anonymous — Wed, 03 Jun 2020 14:30:52 GMT

Thanks Manohar. We have put some Data Quality checks, in our main ETL. However if any other error occurs on the DB, we wanted to capture the row value.

Is there any workaround you see for this?

Re: How to Capture reject records from DBOutput with Batch node on?

manodwhb — Wed, 03 Jun 2020 15:00:39 GMT

@azshaikh , I do not think but you can use on compoent ok from tDBoutput and you can print the error message of global var of tDBoutput.