DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
aluthra48
Participant



Joined: 05 Mar 2009
Posts: 66

Points: 474

Post Posted: Fri Dec 04, 2009 3:27 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have a sort stage in a job to sort incoming data by column A, then B and then C. The receiving stage is a remove duplicates stage where the job picks up the last row. It removes all duplicates with the same values of A and B, except the last row, which happens to be the last value of C within the same A and B.

The warning message I get is
When checking operator: User inserted sort "<name of sort stage>" does not fulfill the sort requirements of the downstream operator "name of remove duplicate stage"

I am trying to remove the warning. What is wrong with 2 stages configured as described above?

Thanks
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 51699
Location: Canberra, Australia
Points: 280769

Post Posted: Fri Dec 04, 2009 11:41 pm Reply with quote    Back to top    

Doesn't the DSXchange Search link work for you?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
currently hiring: Sydney and Melbourne
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