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
- 23701 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 use of surogate key in datastage
What could be a data source system?
in oracle target stage when we use load option and when we use upsert option?
What is the method of removing duplicates, without the remove duplicate stage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Explain how a source file is populated?
what is ds administrator used for?
How to clean the datastage repository?
In Datastage, how you can fix the truncated data error?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
How do you schedule or monitoring the job?
How you can fix the truncated data error in datastage?
Explain connectivity between datastage with datasources?
What are data elements?
