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



how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 record..

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

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 record..

Answer / subhash

for 2nd Qn:
Source is:
Col1 Col2
1 10
2 10
3 10
In transformer, we put the below logic:

Link.Col1 * Link.Col2 + Link.Col2------>Col2

1*10+10------------->20
2*10+10------------->30
3*10+10------------->40

Hope this is fine.

Is This Answer Correct ?    7 Yes 1 No

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 record..

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

Post New Answer

More Data Stage Interview Questions

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,


diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,


SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS

1 Answers  


i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,






What are the different options associated with dsjob command?

0 Answers  


What are the areas of application?

0 Answers  


i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,


Can aggregator and transformer stages use to sort the data? How ?

2 Answers  


What is Cleanup Resources and when do you use it?

2 Answers  


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

0 Answers  


What are the different plug-ins stages used in your projects?

0 Answers  


Categories