DSXchange

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.

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.

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.

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.