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
- 23720 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 roundrobin collector?
What is the difference between orabulk and bcp stages?
What are some prerequisites for datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Define Routines and their types?
How to read the length of word in unix?
Different ways a project can be moved to production ?...example ….export-import and Version control.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the types of containers in datastage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What are the features of datastage flow designer?
What are transforms and what is the differenece between routines and transforms?
What are the processing stages?
Whats difference betweeen operational data stage (ods) and data warehouse?
