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
How to find rejected record count without reject link.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: How to find rejected record count without reject link.
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
If you passed it to a peek stage will help you and it wont store any data physically.
DS User
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Re: How to find rejected record count without reject link.
we want below information:
1> How many records are rejected( we are using db2 connector ,no reject link)
1> How many records are rejected( we are using db2 connector ,no reject link)