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
- 23900 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
What is the difference between informatica and datastage?
What is the precedence of stage variables,derivations, and constraints?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Can you explain players in datastage?
Define data aggregation?
Can you explain engine tier in information server?
What is the use of datastage director?
How do you import and export data into datastage?
How and where you used hash file?
Demonstrate experience in maintaining quality process standards?
whom do you report?
Differentiate between datastage and datastage tx?
What is size of a transaction and an array means in a datastage?
What are the features of datastage flow designer?
How to read the length of word in unix?
