Join stage warning

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
subrat
Premium Member
Premium Member
Posts: 77
Joined: Tue Dec 11, 2007 5:54 am
Location: UK

Join stage warning

Post by subrat »

Can anyone put a quick light into it. Looked into existing entries but didnt really satisfy with those

I am having an issue in below point of a join stage (warning below)

XML stage ---> Transformer ---> Join stage

In transformer:

Preserver partitioning = clear
In Output tab = Preserve sort order(Enable)
RCP (Enable)

I have 3 such transformers which outout to a join stage

In Join:

Join having implicit sort and Unique enable as well with Hash Partion.

warning:
jontes: When checking operator: Operator of type "APT_JoinSubOperatorNC": will partition despite the
preserve-partitioning flag on the data set on input port 0.
buffer(22): When checking operator: Operator of type "APT_BufferOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0.


Wondering even if the partion clear in upstream still getting warning.
kwwilliams
Participant
Posts: 437
Joined: Fri Oct 21, 2005 10:00 pm

Re: Join stage warning

Post by kwwilliams »

There are two input streams into the join stage, are they both XML-->Transformer-->Join, with hash partitioning and sorting on the join input link and clear partition on the transformer output?
Post Reply