Hi,
It is recommended to use the "same" method when the data is sorted in previous stages, however, I'm wondering what if the previous stage is a database stage, that sorts data using the "order by" sql clause.
Can I still use the "same"sorting method?
thanks
Taking the sorted data
Moderators: chulett, rschirm, roy
That's a great question...
If the sort is done by the database (ie: an ORDER BY clause) then DataStage doesn't have visibility to the keys, so "SAME" doesn't quite cover it.
What you should do is insert a SORT stage after the database stage and mark all the keys (and sorting orders) on the stage. Then change all the Sort Key Modes to "Don't Sort - Previously Sorted". This makes sure that DataStage has the required information but won't attempt to resort the data. Any stages after that can use the "Same" option safely.
If the sort is done by the database (ie: an ORDER BY clause) then DataStage doesn't have visibility to the keys, so "SAME" doesn't quite cover it.
What you should do is insert a SORT stage after the database stage and mark all the keys (and sorting orders) on the stage. Then change all the Sort Key Modes to "Don't Sort - Previously Sorted". This makes sure that DataStage has the required information but won't attempt to resort the data. Any stages after that can use the "Same" option safely.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: