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
- 23901 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
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the different options associated with dsjob command?
What is merge stage?
in oracle target stage when we use load option and when we use upsert option?
what is the use of surogate key in datastage
how to run a sequential file stage in parallel if the stage is used on the TARGET side
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is a folder? Difference types of stages?
How to convert RGB Value to Hexadecimal values in datastage?
What all the types of jobs you developed?
What is the difference between orabulk and bcp stages?
How can we improve performance of data stage jobs?
What is the difference between passive stage and active stage?
How many types of sorting methods are available in datastage?
What is the difference between datastage and informatica?
