SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DI studio - order of data - issue

Reply
Occasional Contributor
Posts: 10

DI studio - order of data - issue

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.

Contributor
Posts: 52

Re: DI studio - order of data - issue

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


Cheers from India!

Manjeet
Super User
Posts: 5,431

Re: DI studio - order of data - issue

SQL doesn't preserve original sort order.
If you need original sort order you need to ad more ORDER BY columns.
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 234 views
  • 0 likes
  • 3 in conversation