Target file in different location when there is a reject.

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

Target file in different location when there is a reject.

Post by Sakthi_Sst »

Hi All,

The sceranio is :

I have an input file with 10 records where I have an constraint in the transformer.
Based on my constraints 5 records go in to the target(Taget folder) which satisifies the constraint and the remaining 5 records get in to a reject link(Reject folder).

My requirement is when there is a rejected record I need to send the target file to different location other than the normal location.

When there is a rejected record :
1.Is it possible to send the target file to a different location(Mismatch folder) other than the normal location(Target folder) ?
Sakthi
Raghavendra
Participant
Posts: 147
Joined: Sat Apr 30, 2005 1:23 am
Location: Bangalore,India

Post by Raghavendra »

In After Job sub-routine write a script to check if there is a reject record.If you find reject record then move the file to the required location.
Raghavendra
Dare to dream and care to achieve ...
Post Reply