Datastage
Moderators: chulett, rschirm, roy
-
venkat_april
- Participant
- Posts: 26
- Joined: Mon Jan 23, 2006 12:47 am
Datastage
what is the diff between transform and routines?
Hi venkat,
There are two kinds of routine that you can write in DataStage,one is a Transform function, the other is a before/after subroutine.
Both Transforms and Routines are re-usable components, which are stored in the DataStage Repository.
Transform function routines are called for every row processed, so should be as lightweight as possible.
Before/after subroutines are executed once per job, so can perform some fairly heavy duty processing.
Search this forum,for more information
regards
kcs
There are two kinds of routine that you can write in DataStage,one is a Transform function, the other is a before/after subroutine.
Both Transforms and Routines are re-usable components, which are stored in the DataStage Repository.
Transform function routines are called for every row processed, so should be as lightweight as possible.
Before/after subroutines are executed once per job, so can perform some fairly heavy duty processing.
Search this forum,for more information
regards
kcs
Venkat,
transforms are 1-line codes that are replaced at compilation time; whereas routines are functions that can be of any length you want and are called at runtime. If you change a transformation you need to recompile all jobs that use it; you need only recompile a routine once so that the changes get used in jobs. DataStage differentiates between two types of routines - the "normal" one which is in reality a function as it returns a value, and the "before/after" which is actually a subroutine and has a fixed number of parameters.
transforms are 1-line codes that are replaced at compilation time; whereas routines are functions that can be of any length you want and are called at runtime. If you change a transformation you need to recompile all jobs that use it; you need only recompile a routine once so that the changes get used in jobs. DataStage differentiates between two types of routines - the "normal" one which is in reality a function as it returns a value, and the "before/after" which is actually a subroutine and has a fixed number of parameters.
</a>