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
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Mon Mar 08, 2010 12:05 pm
Hi All,
in sort stage for stable sort option if we select it false, is there any effect on the performance? If it effects please explain how it will effect on performance.
Thanks in Advance
MALLI
asorrell
Posts: 1707 Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas
Post
by asorrell » Mon Mar 08, 2010 1:16 pm
Stable sort means "if you have two or more records that have the same exact keys, keep them in the same order on output that they were on input".
Since keeping track of relative record location means more work, setting Stable to "False" will speed up performance.
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Mon Mar 08, 2010 2:22 pm
Thanks asorrell
But what is the use of sort stage Stabe check box in input tab
MALLI
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Mar 08, 2010 3:52 pm
He explained that. If there's a part in there that is unclear, let us know what.
-craig
"You can never have too many knives" -- Logan Nine Fingers
mallikharjuna
Participant
Posts: 81 Joined: Thu Nov 30, 2006 7:46 am
Location: india
Post
by mallikharjuna » Mon Mar 08, 2010 4:13 pm
In two places i saw stable sort option
1) in Stage>Properties>options>stable sort(true or False)
2) input tab we have to select one check box (perform sort or stable or unique)
My question is what is the difference between these two?
Regards
Mallikharjuna Reddy
MALLI
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Mar 08, 2010 4:14 pm
The Stable Sort check box allows one to assert that the sort specified on the input link is (or is not) to be a stable sort.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dsuser_cai
Premium Member
Posts: 151 Joined: Fri Feb 13, 2009 4:19 pm
Post
by dsuser_cai » Mon Mar 08, 2010 4:18 pm
When you set stable sort to true the input (non key column) sort order is maintained, when you set it to false the sort order is not maintained. basically its used to maintain the order of Non key columns.
Thanks
Karthick