Page 1 of 1

Modify Stage in parallel jobs

Posted: Fri Apr 10, 2009 7:25 am
by venkates.dw
hi,

in parallel jobs modify stage, one of the option is keep column.. what is use of keep column.. give me some explanation with small example

Thanks in Advance....

Posted: Fri Apr 10, 2009 7:33 am
by chulett
Why not just read the chapter on the Modify Stage in the Parallel Job Developer's Guide pdf? Got examples and everything.

Posted: Fri Apr 10, 2009 9:51 am
by ray.wurlod
Any columns you don't KEEP or otherwise derive are dropped.

Any columns you don't DROP are kept.

The two are mutually exclusive, a point which is not well made in the Parallel Job Developer's Guide manual but is well made in the Orchestrate Operators manual.

Posted: Mon Apr 13, 2009 1:54 am
by venkates.dw
Hi, in modify we can perform drop column. keep column . these manipulations we can perform in transform stage, then what is need of this modify stage especially.. Please clarify ..

Thank you,

Posted: Mon Apr 13, 2009 3:01 am
by mahadev.v
Modify stage does not create extra processes. It runs on the output link of the previous stage. So it would be slightly faster than a transformer. AFAIK, the RCP option in each stage also creates a modify operator to propagate or drop the columns.