Hi,
I have to join(left outer join) the data based on two columns. i have used join stage.my source and reference datasets having huge volumes of data. i have used sort stage before doing the join in both source and reference data based on join keys.
my question is which is the best option, with out sort or with sort stage?
Thanks in Advance
Mallikharjuna
Sort Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
Sort Stage
MALLI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Join stage mandates sorted input, therefore the option of "without sort" is moot.
I prefer to use the Sort stage to using input link sorting, because there is greater control and flexibility over resource usage.
I prefer to use the Sort stage to using input link sorting, because there is greater control and flexibility over resource usage.
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.