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

[Anonymous]

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.

[manodwhb]

@azshaikh , can you show your job design?

[Anonymous]

Here it is,

[manodwhb]

@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.

[Anonymous]

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?

[manodwhb]

@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.