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
- 23551 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
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to implement complex jobs in data stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the components of datastage?
How do you remove duplicate values in datastage?
what are the errors,warnings in datastage
What is the difference between datastage and datastage tx?
Differentiate between operational datastage (ods) and data warehouse?
How can you write parallel routines in datastage PX?
What are the various kinds of containers available in datastage?
What are the types of containers in datastage?
What is a ds designer?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Difference between sequential file and data set?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
