How to find rejected record count without reject link.
Posted: Thu Jul 07, 2011 1:39 am
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
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