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
datisaq
Participant
Posts: 154 Joined: Wed May 14, 2008 4:34 am
Post
by datisaq » Tue Aug 11, 2009 4:02 am
In merge stage there is an option as "sort order" available, i given that as "ascending" for my input data.I selected the partition mechanism as "Hash" and i didn't enable any link sort option not even used an external sort stage since the sort option avaiable in merge stage.
But when i compiled the code and saw the generated OSH there is no where the "sort" operator is present.
Did the merge operator itself will do the sorting? Or else
We need to explicilty specify some link sort or sort stage for sorting the data?
Kindly clarify this..
IBM Certified - Information Server 8.1
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Aug 11, 2009 5:35 am
I believe you are telling it the data is already sorted, not asking it to sort the data.
-craig
"You can never have too many knives" -- Logan Nine Fingers
datisaq
Participant
Posts: 154 Joined: Wed May 14, 2008 4:34 am
Post
by datisaq » Tue Aug 11, 2009 6:36 am
No my data is not sorted i thought the option mention over there in merge stage will sort my data.
IBM Certified - Information Server 8.1
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 11, 2009 4:36 pm
You won't see it in the generated OSH. You will see it in the score.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dganeshm
Premium Member
Posts: 91 Joined: Tue Aug 11, 2009 3:26 pm
Post
by dganeshm » Tue Aug 11, 2009 4:53 pm
ray.wurlod wrote: You won't see it in the generated OSH. You will see it in the score. ...
how do we see the score
Regards,
Ganesh
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 11, 2009 6:18 pm
Dump the score into the job log by including the environment variable APT_DUMP_SCORE into your job as a job parameter and setting it to "True".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
datisaq
Participant
Posts: 154 Joined: Wed May 14, 2008 4:34 am
Post
by datisaq » Wed Aug 12, 2009 12:55 am
Thanks Ray for the help..
Yes it's inserting the "tsort" operator.
IBM Certified - Information Server 8.1