Best/easiest way to capture reject records in datastage
Moderators: chulett, rschirm, roy
Best/easiest way to capture reject records in datastage
Hi,
In our project we want to implment reject handling.
Suppose there are 100 records at source & only 95 records moved to target. How can I capture those 5 records? The reason behind rejection might be anything.
Along with that, can I generate reason message for each record?
In our project we want to implment reject handling.
Suppose there are 100 records at source & only 95 records moved to target. How can I capture those 5 records? The reason behind rejection might be anything.
Along with that, can I generate reason message for each record?
Thanks,
Yuva.
Yuva.
transformer
if they are being rejected from a Transformer stage you can click on the 'constraints' button (top left) and set up a reject link
Even though you posted in "General" you marked it as a PX question. Reject links in PX come off the output stage and reflect the input data as well as SQL or other errors where applicable.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Handling of rejects is possible at any point in time in DataStage. You need to know what type of rejects you are looking for - the first response was assuming you had output to a database or output link which failed, other type of rejects such as bad column values are usually handled within the job itself.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
The constraints to a particular link will NOT result setting up a Reject Link to a Trasformer Stage.jtsoong wrote:if they are being rejected from a Transformer stage you can click on the 'constraints' button (top left) and set up a reject link
You might come to say that clicking on the Otherwise/Log in the Constraint of the particular Link and keeping that link at last in the Link Order could catch the (rejected) records which failed to meet constraints on all the previous output links.
For your information:
The conversion of Stream Output Link to Reject Link in a Transformer Stage will happen only when applying "Convert to Reject" action on the Stream Output Link.
Author(yuva010),
Give some extra care when using Otherwise/Log option in the Transformer Stage. Better refer Parallel Job Defveloper's Guide page# 449.
Last edited by ag_ram on Sat May 31, 2008 5:50 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. what type os rejection it is?
is that due to the data comes in source
or
while performing the validation rule in your requirement.
If data you are getting in the source not matches with the job developed those general warnings and errors you can get it in the reject link.
whereas if your requirement expects '1' and 'A' is coming in that if you want to reject the record then you need pull out those records and store it.
you should store the rejected, it won't come automatically
is that due to the data comes in source
or
while performing the validation rule in your requirement.
If data you are getting in the source not matches with the job developed those general warnings and errors you can get it in the reject link.
whereas if your requirement expects '1' and 'A' is coming in that if you want to reject the record then you need pull out those records and store it.
you should store the rejected, it won't come automatically
with regards,
tsn
tsn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: