How to preventing the join stage from sorting the records

balajisr · Post by **balajisr** » Thu Aug 03, 2006 11:18 pm

the auto insertion of partiton and sort happens only if we have auto partition (Datastage).

Kumar,

Now i am bit confused.
For me,Insertion of tsort operator is done even if we hash partition the data with no sorting options.

felixyong · Post by **felixyong** » Fri Aug 04, 2006 12:19 am

balajisr wrote:
the auto insertion of partiton and sort happens only if we have auto partition (Datastage).
Kumar,

Now i am bit confused.
For me,Insertion of tsort operator is done even if we hash partition the data with no sorting options.

Hi,

There is no confusion as the requirement for join is to be sorted. Please see my previous posting on how it can be removed if the source is already pre-sorted.

kumar_s · Post by **kumar_s** » Fri Aug 04, 2006 1:28 am

Iam limited to PX access, so couldnt justy whats been said.
balajisr - Dosent your job any sort (explict sort stage/ inline sort thorugh link).
If no, it shows that, the stages like join, insert an implict sort during runtime (irrespective of the partition been ment).
And this can be controlled only through the environmental varialbe, if not required to sort the data.

balajisr · Post by **balajisr** » Fri Aug 04, 2006 1:39 am

kumar_s wrote:Iam limited to PX access, so couldnt justy whats been said.
balajisr - Dosent your job any sort (explict sort stage/ inline sort thorugh link).
If no, it shows that, the stages like join, insert an implict sort during runtime (irrespective of the partition been ment).
And this can be controlled only through the environmental varialbe, if not required to sort the data.

I do not have any sort operation in my job.

Thanks Felix and Kumar for your clarification.