Preserve sort Order

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
kksr
Participant
Posts: 37
Joined: Fri Dec 30, 2005 5:57 am

Preserve sort Order

Post by kksr »

Hi All,

What is use of Preserve Sort Order option in Transform Stage In PX?

Please help me for the same.

Thanks,
KKSR
KKSR
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Re: Preserve sort Order

Post by priyadarshikunal »

kksr wrote:Hi All,

What is use of Preserve Sort Order option in Transform Stage In PX?

Please help me for the same.

Thanks,
KKSR

Assume that u want to perform sort based on the values of two attributes

a & b

if your incoming data is already sorted wrt attribute a

now when u use preserve sort order it wont sort values of attribute 'a'

and performs a sort on second attribute i.e. 'b';

that saves time as well as other resources.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
kksr
Participant
Posts: 37
Joined: Fri Dec 30, 2005 5:57 am

Post by kksr »

Thanks a lot Priya.
KKSR
Post Reply