how can find maximum salary by using Remove duplicate stage?
- 5 Answers
- 12853 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / narayana.3ds
R.D Stage remove the duplicates every one knows but u can
find max salary......
Give the key of salary order by descending other
option u can put=first
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How many areas for files does datastage have?
What are the different kinds of views available in a datastage director?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the types of hashed files in data stage
Which commands are used to import and export the datastage jobs?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Differentiate between hash file and sequential file?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What are iconv and oconv?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to export or import the jobs in .ISX file
Difference between in process and inter process?
Which algorithm you used for your hashfile?
