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
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Thu Feb 01, 2007 12:46 am
Hello, DataStage Gurus,
I am getting rejected data in sequential stage(flat file). I want to use this rejected data for further prosseing in the same job how can I do this ?
Please help me ?
Thanks
Ashish
Participant
Posts: 57 Joined: Tue Jan 31, 2006 1:16 am
Post
by Ashish » Thu Feb 01, 2007 1:41 am
Can you give me a rough picture about your job design
Thanks
Ashish Arora
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Thu Feb 01, 2007 4:58 am
May be not in the same job. Chances to get Read error or unexpected result based on the design of your job. Why do you need to use it in the same job?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Thu Feb 01, 2007 8:17 am
Its better to modularize you job. But if you insist, I dont see any problem in using the reject file in the same job. Onces all the records are written to the file, only then the read operation is going to start. Thats how it works in server. I am guessing the same rule applies in px as well
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Feb 01, 2007 8:29 am
It would also help if you defined exactly what 'use this rejected data for further processing in the same job' means. And from what I recall, rejected data isn't all that 'usable', per se.
-craig
"You can never have too many knives" -- Logan Nine Fingers
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Thu Feb 01, 2007 10:41 am
Hi,
Thanks for Reply
In my Job I want to load unmatched data in Target Table for that I have used lookup stage and from this stage I am getting Unmatched data as rejected data AND that unmatched(Rejected) data I want to load to Target Table.
Thanks
us1aslam1us
Charter Member
Posts: 822 Joined: Sat Sep 17, 2005 5:25 pm
Location: USA
Post
by us1aslam1us » Thu Feb 01, 2007 11:35 am
swades,
Instead of using the sequential file just drop those rejected records from lookup stage directly to your target table.
PS: It will be better if you post your design.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Thu Feb 01, 2007 11:41 am
Thanks for Reply
I have resolve issue.
Here is what I have done:
I have directed rejected link to Transformer then I loaded to Target Table.
Thanks
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Feb 01, 2007 4:49 pm
Was that a reject link from the Sequential File stage or from the Lookup stage?
I suspect the latter, but we're trying to help future searchers here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
swades
Premium Member
Posts: 323 Joined: Mon Dec 04, 2006 11:52 pm
Post
by swades » Mon Feb 05, 2007 2:05 pm
Sorry for late reply.
Rejected link is from Lookup Stage
Thanks