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.
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.
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.