Hi
I need to implement a job to get the Top 2 nd salary in Datastage.
Datasource is MS Sql Server.
Datastage Version is 7.5 Parallel.
I know we can write a query and keep it in the jobs can achieve.
but i need to build this in Job as we need to improve the performance of the Jobs.
You can take an example data of emp table in oracle database.
Can any one advise how to do this?
How to achieve rank functionality in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is a query, or report. It is not the type of task an ETL should be asked to perform.
There IS a solution, using stage variables. Even without sorting, remember the highest and second highest value thus far processed and, downstream of the Transformer stage, limit output to the last row containing the value(s) of the stage variable(s) as link column(s).
There IS a solution, using stage variables. Even without sorting, remember the highest and second highest value thus far processed and, downstream of the Transformer stage, limit output to the last row containing the value(s) of the stage variable(s) as link column(s).
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.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: