Please help us ....
1)what is the basic Difference between Transformer and BASIC transfomer stage in parallel jobs..
2) and give the limitations/advantages of Transfomer and BASIC transfomer stage in parallel jobs??
Difference between Transformer and Basic Transfomer stage ?
Moderators: chulett, rschirm, roy
ThanX Sunny,,,But a Transformer Stage can also access BASIC transforms, routines and functions Right?? There is no much difference between both the stages.I have gone through Parallel Job developer guide,but i cudnt find any difference.I have not worked on it.
So i cudnt come out with a conclusion.
Practically Do u find any difference??
Thanks,
SumA
So i cudnt come out with a conclusion.
Practically Do u find any difference??
Thanks,
SumA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Transformer stage in parallel jobs can NOT access BASIC functions, etc. It uses a completely different expression editor, with a largely equivalent list of operators, and a different, though overlapping, list of functions and other operands (but they're not BASIC functions and operators).
The BASIC Transformer stage in parallel jobs is a direct equivalent of the Transformer stage in server jobs. Its use will carry a performance overhead, because the BASIC run machine will also need to be loaded when the parallel job is executed. But the convenience might well override this consideration, particularly given the richness of the function set in BASIC.
The BASIC Transformer stage in parallel jobs is a direct equivalent of the Transformer stage in server jobs. Its use will carry a performance overhead, because the BASIC run machine will also need to be loaded when the parallel job is executed. But the convenience might well override this consideration, particularly given the richness of the function set in BASIC.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In parallel jobs there are two, very different, stage types. One is called the Transfomer stage, the other is called the BASIC Transformer stage.
Parallel jobs do not use the DataStage BASIC run machine; instead they use a C-based environment that is/was called osh (from "Orchestrate shell", Orchestrate being the original name for the parallel execution environment acquired by Ascential by purchasing Torrent).
This is why the Transformer stage in parallel jobs does not use BASIC. The BASIC language not supported in osh.
The BASIC Transformer stage in parallel jobs causes osh to invoke the DataStage BASIC run machine for the stage to be executed. This obviously is an extra overhead.
Please note that all this may change in a future revision of DataStage. But it's how things are now.
Parallel jobs do not use the DataStage BASIC run machine; instead they use a C-based environment that is/was called osh (from "Orchestrate shell", Orchestrate being the original name for the parallel execution environment acquired by Ascential by purchasing Torrent).
This is why the Transformer stage in parallel jobs does not use BASIC. The BASIC language not supported in osh.
The BASIC Transformer stage in parallel jobs causes osh to invoke the DataStage BASIC run machine for the stage to be executed. This obviously is an extra overhead.
Please note that all this may change in a future revision of DataStage. But it's how things are now.
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.
-
- Participant
- Posts: 2
- Joined: Thu May 06, 2004 4:01 pm
Difference between BASIC TRM and Parallel TRM
Ray,
I am using the latest release of EE DS 7.5.1.18. When I open my Parallel Canvas, I can see only one Transformer Stage. How can I see or use the Basic Transformer ? Your advice is appreciated.
Thanks in Advance,
HS
I am using the latest release of EE DS 7.5.1.18. When I open my Parallel Canvas, I can see only one Transformer Stage. How can I see or use the Basic Transformer ? Your advice is appreciated.
Thanks in Advance,
HS
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
In your Designer do a right mouse click on the repository window and turn on "Show stage types". Go to the Stage Types - Parallel - Processing folder. You should see BASIC Transformer second on the list. Drag and drop it into your Palette. Your palette is made up of short cuts to your stage types list so you are missing the short cut to the BASIC transformer. You can put your short cut into the Processing palette folder or into your Favourites.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn