use of copystage and modify stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
4friends
Participant
Posts: 71
Joined: Tue May 01, 2007 12:51 pm
Location: Mumbai

use of copystage and modify stage

Post by 4friends »

can anyone explain what are the uses of copy stage and modify stage in what situation can we use?
thanks & regards
kk
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Copy stage makes zero or more copies of its input. You may drop or rename columns, but not change the data in any other way.

Modify stage is a very fast stage for performing certain simple, single-argument functions on data. Vincent has posted a blog on how to become a Modify stage Zen master.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

And Andy Sorrell has a Modify Stage video tutorial which has some good syntax examples. Both stages are faster than the Transformer stage for specialised tasks but the Transformer is easier to use if you are doing multiple tasks in one step (constraints and transforms and copies).
Post Reply