Interested to Buy Any Domain ? << Click Here >> for more details...
how can i get 2nd highest salary in datastage?can u send me
,thanQ
2)if i had source has 2 records 1st record ie 1st column
contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to
get target as 2nd columns as 20,30,40 how can i?
- 3 Answers
- 23703 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ram
there are two ways you can get.
1. sort the data in descending order and make true the
create key change column.
2. this can be done in transformer stage at stage variables.
a. first sort the data on descending order (key would the
column which you wanted to be).
define three stage variables in transformer....sv1,sv2 & sv3
set sv2 and sv3 initial values to 0.
then...
if (salary=sv3) then sv2 else (sv2+1) ------> sv1
sv1 -------> sv2
salary --------> sv3
in next link filter...
constraint sv1=1
now you can see all 1st highest salary, 2nd highest
salary..and so on
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
How do you start developing a datastage project?
What is ibm datastage flow designer?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Difference between in process and inter process?
What is the difference between the local container and shared container?
how to export or import the jobs in .ISX file
What is process model?
Explain connectivity between datastage with datasources?
why do u need the IOS upgradation in a FC switch
What is the difference between odbc and drs stage?
How the ipc stage work?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Whats difference betweeen operational data stage (ods) and data warehouse?
what is flow of project?
What are the types of hashed files in data stage
