processing

ysrini9 · Post by **ysrini9** » Wed May 24, 2006 7:08 am

Hi ALL,

I have a single job in that, I had used 5 transformations to implement the business rule, I would like to know how many number of process will run back-end.

Regards
srini

chulett · Post by **chulett** » Wed May 24, 2006 7:17 am

Why not just run it and see?

ray.wurlod · Post by **ray.wurlod** » Wed May 24, 2006 7:34 am

Are you using row buffering of any kind? This can affect the number of processes.

kumar_s · Post by **kumar_s** » Wed May 24, 2006 7:44 am

Else all the active stages can be combined to a single process. Go though the document given or do a search.
Each passive stages will frame a boundary where the active stages between that will be clubbed together. Also go though the purpose of interprocess stage.

chulett · Post by **chulett** » Wed May 24, 2006 7:52 am

Or... run the job and see!

kumar_s · Post by **kumar_s** » Wed May 24, 2006 8:03 am

Craig -Curious to know the way to find the number of process involved in the job by executing it in server editon.

chulett · Post by **chulett** » Wed May 24, 2006 8:29 am

Grep for the appropriate 'phantom' processes. You'll see one phantom 'DSD.RUN' for the job itself and then one 'DSD.StageRun' process for each 'active' process in the job.

As Ray notes, different settings and stage usage will affect the end result. Each transformer, for instance, could generate a separate process or DataStage could combine them into a smaller number 'under the covers'.