Interested to Buy Any Domain ? << Click Here >> for more details...
How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
- 7 Answers
- 30642 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / nandhini
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Difference between sequential file and data set?
How to find value from a column in a dataset?
How rejected rows are managed in datastage?
How will you move hashed file from one location to another location?
What are the job parameters?
What a datastage macro?
what is the custome stage in datastage? how can we impliment that one? plz tell me
How can we improve performance of data stage jobs?
How do you generate sequence number in datastage?
How many types of views are there in a datastage director?
What is quality stage?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
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
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How do you schedule or monitoring the job?
