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
Can you explain tagbatch restructure operator?
How to read multiple files using a single datastage job if files have the same metadata?
EXPLAIN SCD
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How many types of hash files are there?
Which commands are used to import and export the datastage jobs?
What is a merge in datastage?
What are the types of containers in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Distinguish between informatica & datastage. Which one would you choose and why?
How one source columns or rows to be loaded in to two different tables?
Why do we use link partitioner and link collector in datastage?
What are the differences between datastage and informatica?
What are the some differences between 7.x and 8.x version of datastage?
How can one find bugs in job sequence?