Hi,
Could any one explain me the the difference between external sort and inline sort apart from external sort stage has more options?
I am trying to understand how they differ in terms of creation of OSH,usage of scratch disk and performance impact (If there are any more please mention them as well).
Difference between external sort and inline sort
Moderators: chulett, rschirm, roy
Difference between external sort and inline sort
Manu
Datastage Devoloper
Datastage Devoloper
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Re: Difference between external sort and inline sort
In terms of orchestrate and scratch disk they are the same as they end up with the same tsort operator.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
The difference is that you have quite a few more options with the explicit sort stage as opposed to the implicit sort stage; they call up the same sort by default.
<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:
All three sorts (Sort stage, input link sort and inserted sort) cause a tsort operator to be included in the score. All three are governed by environment variables such as APT_TSORT_STRESS_BLOCKSIZE, obviously, because all three use the tsort operator.
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.