hi all,
how do we apply ranking logic using datastage.
as similar as "RankTransformation" in Informatica.
can any one help me on this
tx in advance
Ranking
Moderators: chulett, rschirm, roy
Hi,
At the current DS version (7) I think you can only use a ranged lookup to a ranking table in order to get the ranks for your mesurements, using between.
Naturally Routines/buildops are also an option but IMHO a lookup to a table is more simple to maintain, hence recomended.
IHTH,
At the current DS version (7) I think you can only use a ranged lookup to a ranking table in order to get the ranks for your mesurements, using between.
Naturally Routines/buildops are also an option but IMHO a lookup to a table is more simple to maintain, hence recomended.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)