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.