Tuesday, 14 August 2012

scenario 3



Input is like this :
i/p
col1,col2
101,a
102,b
103,c
104,d
Output need to be:
o/p
col1,col2
101,d
102,c
103,b
Posted by at

2 comments:

  1. Anonymous5 March 2014 at 21:41

    Split from copy stage to 2(sort the data using hash partitioning on col 1)
    use 1st row generator order by col1 in and generate a key
    use 2nd row generator order by col1 desc and generate a key.
    Join the data and pass appropriate columns.

    Thats it! Cheers!

    ReplyDelete
  2. Unknown6 May 2014 at 04:28

    Thanks For Sharing this article. It's very usefull to all datastage developers.
    Keep sharing. For some more Datastage scenarios.

    ReplyDelete

Subscribe to: Post Comments (Atom)