DI studio - order of data - issue

[89sankar]

I have two DI jobs have exact code and logic. But the order of data becomes different. I am trying to sort the data with emp_no, year, join_datetime. There are two records have same exact above three information. While sorting I get two different orders. DI 4.2 version for both the jobs.

[mnjtrana]

This should not be happening, can you please post a screenshot of the output data?

[LinusH]

SQL doesn't preserve original sort order.
If you need original sort order you need to ad more ORDER BY columns.