Interested to Buy Any Domain ? << Click Here >> for more details...
how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 14940 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
By using Sort stage, sort the data in Descending order, then
use remove duplicates stage, set option as first occurrence
of records. Then we will get max sal record first.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is the difference between == and eq in UNIX shell scripting?
What is staging variable?
Which algorithm you used for your hashfile?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How you can fix the truncated data error in datastage?
What are the different options associated with dsjob command?
What are the important features of datastage?
what is the use of skid in reporting?
How can one find bugs in job sequence?
What is apt_config 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 get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Could anyone give brief explanation bout datastage admin
what is the custome stage in datastage? how can we impliment that one? plz tell me
