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?
Answer Posted / 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 |
Post New Answer View All Answers
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How to convert RGB Value to Hexadecimal values in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the areas of application?
How many types of sorting methods are available in datastage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
Name the different types of Lookups in Datastage?
What is a folder? Difference types of stages?
What is the command line function to import and export the ds jobs?
What are orabulk and bcp stages?
Differentiate between odbc and drs stage?
How to RD using transformer?
What are the types of views in datastage director?
client know skid info?
What is the difference between informatica and datastage?