Hi,
I know that Routine will return only one vale.Is it right or wrong,reply me.And what is the difference between Routine and Transform.
Thanks,
sudhakar
Difference between Routine and Transform
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Difference between Routine and Transform
i need to know datastage
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
Although the topic has been covered several times, the answer isn't that complicated. A DataStage "Routine" is actually a function in most programming languages, it takes 0 through 254 arguments and returns a single value value. A DataStage transform is effectively also a function in that the whole transform gets evaluated to a single value at runtime,but the difference is that when you use a transform in a DataStage job the contents of the transform are inserted into the job at compile time; Routines are called by reference.
One difference is that when you change a transform you will need to recompile all jobs that use it and you do not need to do that with Routines. Since transforms don't have the overhead of calling a catalogued routine they execute faster than routines. Transforms are limited to single-line constructs while Routines can be very long and complex programs.
One difference is that when you change a transform you will need to recompile all jobs that use it and you do not need to do that with Routines. Since transforms don't have the overhead of calling a catalogued routine they execute faster than routines. Transforms are limited to single-line constructs while Routines can be very long and complex programs.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 85
- Joined: Fri Nov 18, 2005 5:35 am
I have to say that the official training is wrong on point (1) and although strictly speaking point (2) isn't incorrect it doesn't explain the major difference in how the code is executed at runtime.
The initial purpose might have been to use specific data type and elements in transforms, but it is not controlled and the purpose of a transform is not to transform from one data type to another.
The technical term for what transforms do is "inline expansion".
The initial purpose might have been to use specific data type and elements in transforms, but it is not controlled and the purpose of a transform is not to transform from one data type to another.
The technical term for what transforms do is "inline expansion".
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>