How to achieve rank functionality in Datastage
Posted: Mon Aug 02, 2010 1:40 am
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?
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?