How to do Sorting without Sorting stage

You can do it as normal process first as follows. 

If we want to read the data using Sequential File 

Design as follows : ------------- 

Seq. File ------------------------Dataset File 


To read the data in Sequential file 

Open Properties of Sequential file 

and give the file name. 

Now you can give the file path, by clicking on the browse for the file. 

And in Options select True ( If the first line is column name ) 

You can just leave the rest of the options as it is. 

Now go to Column and click on load, then select the file you like to read from the 

table definitions . 

( This file should be same which you have given in the properties. ) 

Now in the Target Dataset - Give file name. 


Now for the sorting process. 

In the Target Open Dataset properties 

And go to Partitioning ---- Select Partitioning type as Hash 

In Available Columns Select Key Column ( E_Id for EXAMPLE) to be sorted. 

Click Perform Sort 

Click Ok 

Compile And Run 

The data will be Sorted in the Target.