Page 1 of 1

reformatting records

Posted: Mon Aug 10, 2015 6:36 pm
by India2000
Hi,

I have a scenario where I need to convert records in the order

order no seq no

01 01
01 02
01 03

02 01
02 02
02 03

to

01 01
02 01
01 02
02 02
01 03
02 03


can any one please let me know how can we achieve this? Thanks

Posted: Mon Aug 10, 2015 6:58 pm
by rkashyap
Read about SORT stage.

Posted: Mon Aug 10, 2015 11:53 pm
by ray.wurlod
... and pay particular attention to partitioning requirements therefor.