Partitioning with Transformer stage

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
rexsmith
Participant
Posts: 64
Joined: Sun May 14, 2006 8:57 pm

Partitioning with Transformer stage

Post by rexsmith »

Is it possible to partition/re partition the input data within the transformer stage. I tried doing it doesnt allow me to partition it says unknown name!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes it's possible. Open the stage properties, select the Inputs tab, select the Partitioning tab. Choose the partitioning algorithm from the drop-down list. On the Outputs tab you can set the Preserve Partitioning flag.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Minhajuddin
Participant
Posts: 467
Joined: Tue Mar 20, 2007 6:36 am
Location: Chennai
Contact:

Post by Minhajuddin »

But just a word of caution!

Don't re-partition your data unless you really need it.

As partitioning is an overhead and if you do repartitioning it definitely reduces the performance of the jobs. :wink:
Minhajuddin

<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
rexsmith
Participant
Posts: 64
Joined: Sun May 14, 2006 8:57 pm

Post by rexsmith »

Well, i tried doing it . whenever i tried to set the alogrithm from the drop down and hit ok it says " unknown name " . I tried all the partitioning alogrithms. it doesnt work . :(
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Report a bug in the version 8 client to your support provider. It works fine in version 7.5.2.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rexsmith
Participant
Posts: 64
Joined: Sun May 14, 2006 8:57 pm

Post by rexsmith »

I remember doing it in 7.5, Any way thank you every one for your inputs.
sbb
Participant
Posts: 6
Joined: Thu Mar 23, 2006 12:58 am

Post by sbb »

Hi Rexsmith, Could you suggest me how did you fixed this, am getting the same error while selecting the input partition in Transformer.

thanks
sbb
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

Contact IBM for patch ; it's a bug in the client software.
algfr
Participant
Posts: 106
Joined: Fri Sep 09, 2005 7:42 am

Post by algfr »

John Smith wrote:Contact IBM for patch ; it's a bug in the client software.
I have a workaround :

When the message appears, go to the stage tab. The message should keep on popping out. Keep pressing ENTER. At some point, DS lets you go out and when you come back in, the change is recorded.
Post Reply