We want to eliminate duplicate records and sort on position 10. This is trivial to do in two steps; but can it be done in one? (My team lead feels that one step with a hundred control cards is less "messy" than two steps with a total of three control cards .)
Joined: 03 Oct 2009 Posts: 1775 Location: Bloomington, IL
Well, it's not a problem per se. Unlike some querents, I have no problem with telling project managers and BAs, "What you want can't be done". I'm not a *Sort/*Tool maven, though; maybe it could be done, and I just didn't know how.
In any case, my team lead has little enough experience with SyncSort, and none with SyncTool; I have more with *Sort (although, as I said, I'm by no means an expert), but also none with *Tool. I helped him with the two-step sort job (and told him firmly, "You can't allocate the same data set to both SORTIN and SORTOUT! Bad team lead! No Jolt"! ); until it's shown that its performance is unacceptable, I decline to go further.