Reject Id and Reject Description

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Sakthi_Sst
Participant
Posts: 36
Joined: Wed Aug 09, 2006 12:18 am
Location: Chennai

Reject Id and Reject Description

Post by Sakthi_Sst »

Hi All,

I need to generate a Reject Id and Reject Description for a rejected record.
I have 2 files when i do a lookup some records are rejected due to key identifiers not matching.
I capture that in a reject file.

For ex.When i do a lookup based on a Member Id,when the unmatched records get rejected, it should be rejected along with 2 columns Reject Id and Reject Description Say:Reject Id : 01 and Rej Desc : Not matched in Source.

Can you guide me in handling this scenario?
Sakthi
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

Did you feel any inconvenience while adding a Transformer Stage in between Look-up Stage and Reject File Stage along with the derivation of those two columns.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Insert a Column Generator (or Transformer) stage on the reject link to generate the required constants.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply