Page 1 of 1
processing
Posted: Wed May 24, 2006 7:08 am
by ysrini9
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
Posted: Wed May 24, 2006 7:17 am
by chulett
Why not just run it and see?
Posted: Wed May 24, 2006 7:34 am
by ray.wurlod
Are you using row buffering of any kind? This can affect the number of processes.
Posted: Wed May 24, 2006 7:44 am
by kumar_s
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.
Posted: Wed May 24, 2006 7:52 am
by chulett
Or... run the job and see!
Posted: Wed May 24, 2006 8:03 am
by kumar_s
Craig -Curious to know the way to find the number of process involved in the job by executing it in server editon.
Posted: Wed May 24, 2006 8:29 am
by chulett
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'.