how many process will create

[4friends]

if am runing a job on three node and having 3 stages then how many process will create

[ray.wurlod]

Thirteen.

Unless there is operator combination or some other optimization happening.

[Raamc]

Rey,

May i know the process how you calculated the number of processes?

[ArndW]

This answer might also change if you are using a partitioned DB2 database as source/target/lookup as well.

[4friends]

Thirteen.

Unless there is operator combination or some other optimization happening. ...

if i am having stages like

dataset---->transformer---->targetdatabase.
and running on three node.

can u tell me where we can get this information.plz

[ray.wurlod]

The simplest model is where there is no operator combination. Each operator (for simplicity) represents one stage. You have three stages, therefore three operators, on each of three processing nodes. That makes for a total of nine "player" processes executing the operators. Each processing node has a "section leader" process looking after co-ordination on that particular node, and there is one "conductor" process (the startup process) managing overall co-ordination and logging.
Nine player processes, three section leader processes and one conductor process equals a total of thirteen processes.