DSXchange

I have a sequential file as Sort stage input containing data like :

empid
1
2
3
1
2
4
4

Now when I use the Sort stage on this input file with ascending empid (Allow Duplicate=True,all other options default), I get the following output

empid
3
1
1
2
2
4
4

which shows repeating values are sorted but non-repeating value('3') comes in wrong position.

Please explain this behaviour.

what is your target?

My target is a data set

Dataset displays data from more than one partitions and the data is sorted within partitions in dataset.

Write the data to the sequential file and find out if there are any differences.

yes...It is appearing correctly in sequential file..thanks