Using sort after aggregator

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
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes, but its absence will cause the framework to insert a tsort operator in any case, unless you use input link sorting on the Join stage. Because the Join stage requires sorted input, DataStage makes sure it can "see" something - directly on the input link - that guarantees sorted data.

Better, I feel, would be to leave the Sort stage in place, but to set its Sort Mode property to "Don't Sort, Previously Sorted".
Presence of the Sort stage comforts the Join stage into not inserting any different form of tsort operator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply