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?
Answers were Sorted based on User's Feedback
Answer / farzana kalluri
seq file--->sort(descending)stage--->surrogate key stage---
>target
sort tha data in descending order ,then it will shows from
highiest salary, after that keep surrogate key stage it
will automtaically generates the nos so that we can
identifiy the 2nd hieght salary .
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / 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 |
how to remove duplicates in transformer stage by using stage variables?one example?
What is the difference between odbc and drs stage?
What is a datastage job?
specify data stage strength?
how to write server Routine coding?
Describe link sort?
how to handle null values using transformer stage?
How rejected rows are managed in datastage?
detail about sdlc
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
how to get the unique records on multiple columns by using sequential file stage only
I have 100 records how can I load at a time from the single time