DataStage 8.0.1 version is transformer advised to used??

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Tue Jul 22, 2008 2:48 am

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

balajisr · Post by **balajisr** » Tue Jul 22, 2008 3:10 am

Yes. Transformer has been vastly improved from version 7.5.1 or 7.5.2, i do not remember exactly.

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Tue Jul 22, 2008 3:19 am

You mean to say a Transformer is advised to use instead of a copy stage..
In 7.5x we prefer a copy stage instead of a transformer..

In 8.0.1 a transformer is preffered instead of copy..?? How does IBM justify this.???

ray.wurlod · Post by **ray.wurlod** » Tue Jul 22, 2008 4:01 am

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.

balajisr · Post by **balajisr** » Tue Jul 22, 2008 4:44 am

In 8.0.1 a transformer is preffered instead of copy..??

No. As Ray mentioned copy or modify is always much efficient than transformer.

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

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Tue Jul 22, 2008 6:56 am

Thanks a lot for the information... So even in 8.0.1 version copy, modify stage are preferred to Transformer..!!! :D

bikan · Post by **bikan** » Wed Jul 23, 2008 12:09 am

Then why..they keep this..copy..filter etc stage...they can remove all that and keep onlt transformer stage instead

ray.wurlod · Post by **ray.wurlod** » Wed Jul 23, 2008 12:17 am

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.

manuel.gomez · Post by **manuel.gomez** » Wed Jul 23, 2008 3:49 am

Fantastic post!!!!!!!!