Comparision between Px Transformer & Pivot 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
hhh
Participant
Posts: 86
Joined: Tue Aug 02, 2005 7:39 am

Comparision between Px Transformer & Pivot stage

Post by hhh »

Hi All,

There is a requirement to load large amount of data and for that i need some inputs on pivot stage and parallel transfer stage, which one is most faster !!

could any guide me comparison between pivot stage and px transformer stage.

Appreciate you help !!
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

Hello hhh,

Am I right in assuming 'parallel transfer stage' refers to a Transformer? Asking which of a Transformer or Pivot stage is faster is like comparing a Kettle and a Toaster: They're both pretty fast and efficient tools at achieving what they were designed to do.

I'm assuming you're referring to performance speed rather than speed/ease of development? In that case, tell us how you plan to emulate the behaviour of the pivot in the transformer and someone might provide some clues on how you could best optimise that solution. Also 'How fast' also depends upon your environment's capabilities and configuration.

Other than that, the quickest way to a concrete answer is to build both and try them - and then post your experiences here. :-)

J.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... and don't try to boil water in a toaster or cook bread in a kettle!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Well... you could try. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
jhmckeever
Premium Member
Premium Member
Posts: 301
Joined: Thu Jul 14, 2005 10:27 am
Location: Melbourne, Australia
Contact:

Post by jhmckeever »

Sorry for the weak analogy - I had kitchen appliances on my mind at the time:

If anyone living in East Melbourne, Australia, had a power cut last Saturday night (about 2 minutes after completion of the Australian Open Men's Finals) then I apologize. It was due to my kettle exiting this world dramatically. It took about 12 hours to get the electricity restored.

No fatalities were recorded, although the kitchen is still in a critical condition. :(

John.
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Post Reply