DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
cppwiz
Participant



Joined: 04 Sep 2007
Posts: 135

Points: 1273

Post Posted: Thu Sep 11, 2008 12:35 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: Why use a transformer stage to parse rejects?
I inherited some jobs that were built under version 7.5 but now we're running v8. In each job, the lookup stages do not send rejects down a reject link. Instead, a transformer stage parses the rejects after the lookup stage and sends the rejects down a link using stage variables.

Was there a bug in past versions of DataStage that prevented the lookup stage from correctly rejecting records? Is this a best practice that I should continue in new jobs or is it safe to use the built-in lookup reject functionality?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Thu Sep 11, 2008 5:32 pm Reply with quote    Back to top    

There was no such bug. The problem would appear to have been between the keyboard and that job's developer's chair.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
cppwiz
Participant



Joined: 04 Sep 2007
Posts: 135

Points: 1273

Post Posted: Fri Sep 12, 2008 9:51 am Reply with quote    Back to top    

Thanks Ray. Maybe it was just done to add an extra description of the lookup failure like "Department Code Not Found". Is there another way to add a reject description from the Lookup stage?
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Fri Sep 12, 2008 5:52 pm Reply with quote    Back to top    

No there isn't. In parallel jobs it's one stage, one task. That sounds like a good reason to process through a Transformer stage. Of course that Transformer stage (or a Column Generator stage) coul ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours