Hi,
I am using pivot stage in my job. The pivot runs in sequential mode as default.
If i cahnge it to parallel, will my functinality affects or not. Shall i change it to parallel.
My Functionality is :
I am getting four fields from pivot input and writting one filed in pivot output.
Kindly help me.
Pivot stage in parellel mode.
Moderators: chulett, rschirm, roy
This is a very basic PX type question that we cannot answer for you. If the pivot can be done within the datasets in each processing node then you should be able to work in parallel. You should try it and see if it works and perhaps provide some feedback to the forum when you've finished.
I looked into the documentation on my PC with 7.5.2 and couldn't find the PIVOT stage documented for PX! I don't know if I might have deleted it by mistake.
I looked into the documentation on my PC with 7.5.2 and couldn't find the PIVOT stage documented for PX! I don't know if I might have deleted it by mistake.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not so. The only difference for execution mode is that, for parallel mode, you must partition (and, ideally, sort) on all pivot key columns. For sequential mode, since all rows are in the same partition, this is not necessary, through sorting is still beneficial.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.