Page 1 of 1
How to use Before/After Stage Routine in the Transformer
Posted: Wed Mar 22, 2006 4:09 am
by Madhu1981
Hi,
I have written a before/after server routine. I want to use this routine in the stage level. Can any one tell me, on which stage i can use this before stage routine.
Shall i use this serverr routine in Transformer(PX) stage.
Kindly help me
Posted: Wed Mar 22, 2006 4:22 am
by ArndW
If you use the routine in a BASIC transformer stage in PX it will get executed on every row of the data and will slow down the job. If you use it at the job level of a PX job it will only get executed once.
What is your server routine supposed to be doing?
Posted: Wed Mar 22, 2006 4:22 am
by balajisr
You cannot use px transformer to call server routine. You need to use basic transformer to call server routine.
Posted: Wed Mar 22, 2006 4:47 am
by Madhu1981
Hi Arnd,
Is there any parellel stage where i can call my server routine as before stage routine.
Kindly Help me
Posted: Wed Mar 22, 2006 4:59 am
by ArndW
No, there are no parallel stages that will allow you to call server routines. They exist in completely different environments and are not compatible that way. You can only use a server routine from a BASIC transform stage in PX.