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
- 23745 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
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to delete one row in target dataset
Could anyone give brief explanation bout datastage admin
How to manage date conversion in Datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
CHANGE CAPTURE
What is the difference between Datastage 7.5 and 7.0?
Differentiate between hash file and sequential file?
Does datastage support slowly changing dimensions ?
What a datastage macro?
Differentiate between datastage and datastage tx?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Define project in datastage?
How to perform incremental load in datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
