Hi All,
I am new to datastage and I am working on the following requirement.
I have source data and I have to sort this data in a descending order and provide the ranks for only top 5 . But the data can contain zeroes also. If the colB =0 then use another column to get the rank.
Please help me in doing this . I appreciate it.
Thanks
--DSDEV
Datastage requirement
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
To my way of thinking, RANK is a display function, not something that an ETL tool should be asked to do.
It is possible, which a Search of DSXchange will reveal.
Begin by formulating your complete logic in English - this should readily translate into operations in the ETL job itself.
To my way of thinking, RANK is a display function, not something that an ETL tool should be asked to do.
It is possible, which a Search of DSXchange will reveal.
Begin by formulating your complete logic in English - this should readily translate into operations in the ETL job itself.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.