Reject handling in postgresSQL

[gervit14]

Hi all,

I am doing reject handling in tmap and using tpostgresqlOutput component.

Problem is if any record got fail to load in target db,ideally this particular record should go to the reject flow and subsequent should go in the target but in my case if any record got rejected due to some constraint issue, subsequent all records (which are good records) are going to the reject flow.

Please help me in this.

[Anonymous]

I am not sure if this can be done. I think that only reject data can go to that file, you can make the job to fail if "some constraint issue" happens.

If you know which issue can happen you can add another output and put some filter.

[Anonymous]

Hi

The issue is not very clear for me.

Are you handling reject on tmap or tDBOutput or both?

[gervit14]

I am taking reject flow from the tpostgresoutput component (keeping 'die on error' unchecked) and not at tmap side.

[gervit14]

Thanks for your reply.

You are correct, ideally only the record having constraints violation should go to reject, but in my case if any one record got rejected by any constraint violation, all the subsequent record (which are not having constraint violation) are also going to the reject flow.