Warning - Sort Stage

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
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Warning - Sort Stage

Post by devidotcom »

I have observed that in most of my parallel jobs whihc uses a sort stage gets this kind of warning.
Could any one please elobrate and tell me why I get this error.

Here in this sort stage 'Sort_Brck_Mrtr_Str_I' has the partitioning done on the column BRCK_MRTR_STR_I. I perform a hash partitioning on this key in the sort stage.

Sort_Brck_Mrtr_Str_I: When checking operator: Operator of type "APT_TSortOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.
ashwin141
Participant
Posts: 95
Joined: Wed Aug 24, 2005 2:26 am
Location: London, UK

Warning - Sort Stage

Post by ashwin141 »

Set the Preserve Partitioning Flag to Clear, that weill solve the problem.

Cheers!
Ash
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

You could have replied to this in the other post so that this post can be deleted. :roll:
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Post by devidotcom »

Thanks for the reply...
ashwin141
Participant
Posts: 95
Joined: Wed Aug 24, 2005 2:26 am
Location: London, UK

Warning - Sort Stage

Post by ashwin141 »

Hey Bala,

I saw this post and just replied - didn't realise that it's duplicate and has been answered already.

Cheers!
Ash
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Post by devidotcom »

If I have a link sort done on the left link of the join then I get the error.
The input comes from the transformer stage I checked to clear partitioning in the output link yet I get the error...
Ash could u help me here.
devidotcom
Participant
Posts: 247
Joined: Thu Apr 27, 2006 6:38 am
Location: Hyderabad

Post by devidotcom »

Got it... thanks again..
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

No one has replied to your other post. You can go ahead and delete that one.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply