How to use Before/After Stage Routine in the Transformer

Madhu1981 · Post by **Madhu1981** » Wed Mar 22, 2006 4:09 am

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

ArndW · Post by **ArndW** » Wed Mar 22, 2006 4:22 am

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?

balajisr · Post by **balajisr** » Wed Mar 22, 2006 4:22 am

You cannot use px transformer to call server routine. You need to use basic transformer to call server routine.

Madhu1981 · Post by **Madhu1981** » Wed Mar 22, 2006 4:47 am

Hi Arnd,

Is there any parellel stage where i can call my server routine as before stage routine.

Kindly Help me

ArndW · Post by **ArndW** » Wed Mar 22, 2006 4:59 am

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.