Sort issue in transformation

[Former Member]

Hi expert, I have a sort issue. When I debug the DTP, the data in source package like below:

doc_num item date

DOC001 10 20110503

DOC001 10 20110502

DOC001 20 20110503

DOC001 20 20110502

in start routine, I use "sort source_package by doc_num item".

after the start routine done, I found the data like below:

DOC001 10 20110503

DOC001 10 20110502

DOC001 20 20110502

DOC001 20 20110503

Could anyone know the reason, why the same condition will has different result.

Thank you in advance.

Edited by: YAODAN on May 16, 2011 9:24 AM

[Former Member]

Thank you

[former_member610149]

Hi YAODAN,

It again depends whether you declared any symantec key or not. Indirectly packet size also plays a role. You need to consider all these. As per the example given, the sorting works fine. Isnt it.

With best wishes

BaaRaa.

[Former Member]

Hi

since you have chosen only doc no and item i dont think system bothers to check date here.

try debugging with a bit alrger data set and you will find randomness in this observation.

is there any problem you are facing here??

Regards

Sudeep