DSXchange

can my job performance will improve with the use of copy stage if my source and target is same db(db2)? anyone can tell me how?

Copy stage, like its name, just makes copies of your input. It has nothing to do with your source and target. It will make copies regardless. Its performance is pretty good too.

You can drop or change the order of columns. You can have extra copies for backup purpose.

But I don't think that adding a Copy stage between your DB Stages would improve Performance.

Minhajuddin wrote:But I don't think that adding a Copy stage between your DB Stages would improve Performance.

Right. The copy stage is intended to make copies of the input stream. If that is not the intension then un-necessarily do not stick in any stage.

A Copy stage that does nothing will be optimized out of the design when the score is composed.

While the Copy stage is not permitted to change or add data, it can do any or all of the following:
- re-order columns
- drop columns
- rename columns

If there is any enhancements in your job in the future this copy stage(placeholder) will be useful.i think it wont improve the performance of a job

A Copy stage with no output link is an excellent placeholder while you are effecting incremental design. It will consume all the rows sent into it and have nowhere to transfer them, so will simply discard them.