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
- 23552 Views
- Accenture, I also Faced
- E-Mail Answers
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
How do you schedule or monitoring the job?
What is the difference between server job and parallel jobs?
How to clean the datastage repository?
What is process model?
How do u convert the columns to rows in datastage?
what is the difference between == and eq in UNIX shell scripting?
options available in sequence job to run,validate?
What is job control?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the different type of jobs in datastage?
What is the project in datastage?
What are the types of hashed files in data stage
Name the different sorting methods in datastage.
how many rows sorted in sort stage by default in server jobs
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
