why to use copy stage .....
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Mon May 28, 2007 12:41 am
- Location: Chennai
why to use copy stage .....
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?
-
- Participant
- Posts: 15
- Joined: Mon Mar 20, 2006 2:03 pm
Re: why to use copy stage .....
You can drop or change the order of columns. You can have extra copies for backup purpose.
What's the next?
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
But I don't think that adding a Copy stage between your DB Stages would improve Performance.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
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.Minhajuddin wrote:But I don't think that adding a Copy stage between your DB Stages would improve Performance.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 13
- Joined: Mon Sep 11, 2006 8:01 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.