Performance between stages
Moderators: chulett, rschirm, roy
Performance between stages
Would a sort/filter combination yield better performance than a transformer just by itself?
I can see how a Transform stage can act like a filter, but the sort portion of the question is unclear to me as a transform stage doesn't have anything like that functionality. Any job without a sort is going to be faster than one with.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The answer for Filter vs Transformer (no sort in either case) will depend on the version of DataStage you are running. In 7.5.1 and later - all else being equal, that is you are not having the Transformer do any other processing - the difference will be negligible.
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: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Better" in what way? Probably no significant difference.
The Filter stage does not require sorted input - without knowing precisely which post you are referring to I can not comment on that "solution".
The Filter stage does not require sorted input - without knowing precisely which post you are referring to I can not comment on that "solution".
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.