How to find rejected record count without reject link.

[chandra.shekhar@tcs.com]

Hi,
As per the business requirement ,we have to find the rejected record count.

my job as follows:


src_db2_connector----->transformer----->Tgt_db2_connector(Upsert mode)
|
|
-------------exception_tgt_db2 connector


Tgt table having primary key. when duplicate records are come job will abort. we dont want to job should abort .it should complete the processing and should give me the rejected record count without the reject link.

What is the scenario when rejects will happen? It has been observed that in case of any data rule violation (PK/Length etc), the job fails.Will the reject information be available in the log without having Reject link? It has been noticed that whenever there is no Reject link in the job, there is no information on the reject.


Kindly suggest.
Kishor

[ray.wurlod]

This is a joke, right?

You must have a reject-handling link if you want to obtain information about rejected rows (of course, these will probably be captured in the database logs, but that's a whole different story).

[SURA]

You dont want the reject data or reject link itself?

If you passed it to a peek stage will help you and it wont store any data physically.

DS User

[chandra.shekhar@tcs.com]

we want below information:

1> How many records are rejected( we are using db2 connector ,no reject link)