Hi,
In Copy stage whats the difference if i keep the set Force option as True or False.
I have a Job where there are one input and two Output to copy stage. In this case shall i keep the Force option as True or False and why?
Thanks
Copy Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: Copy Stage
Setting force option "True"subrat wrote:Hi,
In Copy stage whats the difference if i keep the set Force option as True or False.
I have a Job where there are one input and two Output to copy stage. In this case shall i keep the Force option as True or False and why?
Thanks
Specifies that Orchestrate cannot attempt to optimize the step by removing
the copy operator.
In some cases, Orchestrate can remove a copy operator if it determines that
the copy operator is unnecessary. However, your application may require the
copy operator to execute. In this case, you set the force option true.
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why not prove it either way? Run the job with Force set and not set, capturing and examining the Score. Which one has no copy operator? (Note that the Copy stage must be a straight-through copy (no changes) to be eligible to be optimized out.)
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Examining not only contains examining the out putsubrat wrote:ray.wurlod wrote:Why not prove it either way? Run the job with Force set and not set, capturing and examining the Score. Which one has no copy operator? (Note that the Copy stage must be a straight-through copy (no ...
For my scenario it s giving me the same output in both case.
but the performance and the OSH Script is also there.
to see whether the datastage optimizes your code or not.
so try with single output too.
Regards,
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: