Need help with sorting the data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
Need help with sorting the data
I am joining two datasets using the join stage, to sort the incoming data which of the two is best:
1) In link sort
2) using 2 sort stages explicitly on both links
It would be of great help if the reason is specified.
Thanks..........
1) In link sort
2) using 2 sort stages explicitly on both links
It would be of great help if the reason is specified.
Thanks..........
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Both are the same as far as only sorting (using datastage sort) is concerned as both will insert a tsort operator.
but an explicit sort stage give you more options than inlink sort like
getting key change column, liberty to select the utility used for sorting (Datastage/Unix), It can dump stats and also you can restrict the memory usage from the stage itself.
but an explicit sort stage give you more options than inlink sort like
getting key change column, liberty to select the utility used for sorting (Datastage/Unix), It can dump stats and also you can restrict the memory usage from the stage itself.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I disagree 100%. But I'd be interested to hear your reasons.srinivas.g wrote:Performance wise Inline sort is best compare to explicit sort stages.
Two reasons an explicit Sort stage is better (and can be better for performance):
- you can control the amount of memory allocated
you can generate key change indicators
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.