input file data sort order and output file data order
Posted: Wed Oct 17, 2012 5:24 am
Hi,
We have observed below data order in the data when it is written to output file. This is a server job. Could anyone please explain.
We have input data order as mentioned below.
ID|NAME
1|A
2|B
3|C
4|D
Job is very simple and no contraints involved.
In output file, the data order should be same as it is in the input file. But, it is giving in below order. Basically, row order is changing. Could you please explain why?
ID|NAME
3|C
2|B
1|A
4|D
Thanks
We have observed below data order in the data when it is written to output file. This is a server job. Could anyone please explain.
We have input data order as mentioned below.
ID|NAME
1|A
2|B
3|C
4|D
Job is very simple and no contraints involved.
In output file, the data order should be same as it is in the input file. But, it is giving in below order. Basically, row order is changing. Could you please explain why?
ID|NAME
3|C
2|B
1|A
4|D
Thanks