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
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the main features of datastage?
What is ds designer?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Nls stands for what in datastage?
What is process model?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Can you explain repository tables in datastage?
CHANGE CAPTURE
Could anyone give brief explanation bout datastage admin
How many types of views are there in a datastage director?
Distinguish between informatica & datastage. Which one would you choose and why?
State the difference between an operational datastage and a data warehouse?
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)