DataStage 8.0.1 version is transformer advised to used??
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
DataStage 8.0.1 version is transformer advised to used??
Hi..
We have been developing some jobs using datastage 8.0.1 version.. For some small modifications we had to achieve,we used modify stage. But our Onshore has asked us to replace it by Transformer.. we have been advised to use Transformers for even small operations like copy, modify etc..
We have been told that in 8.0.1 version performance doesnt go down even though we use many transformers.. Is it true..
The rules that hold good for 7.5.x doesnt hold good for 8.0.1 isnt???? I mean in 7.5.x we were advised to avoid transformers.. Kindly advise
We have been developing some jobs using datastage 8.0.1 version.. For some small modifications we had to achieve,we used modify stage. But our Onshore has asked us to replace it by Transformer.. we have been advised to use Transformers for even small operations like copy, modify etc..
We have been told that in 8.0.1 version performance doesnt go down even though we use many transformers.. Is it true..
The rules that hold good for 7.5.x doesnt hold good for 8.0.1 isnt???? I mean in 7.5.x we were advised to avoid transformers.. Kindly advise
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
They can sell you bigger hardware.
The Copy stage, if it is suitable for the required task, is infinitely to be preferred to a Transformer stage performing the same task. The same remains true of the Modify stage, but less so for Filter and Switch stages.
The Copy stage, if it is suitable for the required task, is infinitely to be preferred to a Transformer stage performing the same task. The same remains true of the Modify stage, but less so for Filter and Switch stages.
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.
No. As Ray mentioned copy or modify is always much efficient than transformer.In 8.0.1 a transformer is preffered instead of copy..??
But transformer is certainly no evil and i prefer it to modify stage.
Check this blog by Vincent.
http://it.toolbox.com/blogs/infosphere/ ... -evil-9801
-
- Participant
- Posts: 42
- Joined: Mon Apr 21, 2008 1:49 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The philosophy is "one stage, one task". If ALL you want to do is copy, then a Copy stage is way more efficient.
The Transformer stage is an aberration. It's been put in so that you don't have to create buildops for every single transformation. These days, if you examine the code generated by compiling a Transformer, you will see that it is markedly reminiscent of a buildop. Because that's effectively what it is; an operator.
The Transformer stage is an aberration. It's been put in so that you don't have to create buildops for every single transformation. These days, if you examine the code generated by compiling a Transformer, you will see that it is markedly reminiscent of a buildop. Because that's effectively what it is; an operator.
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.
-
- Premium Member
- Posts: 291
- Joined: Wed Sep 26, 2007 11:23 am
- Location: Madrid, Spain