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
- 30432 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / naga
firstly read the file into database or sequential file and
make sure the file has company as a column in this file and
give its output to aggregator and in aggregator give
group=company and column to calculate=sal and maximum value
for output column=maxsal and do mapping to the dataset and
you will get the required result.
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
Define Job control?
how many rows sorted in sort stage by default in server jobs
What are the types of jobs we have in datastage?
What are system variables and sequencers in datastage
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What all the types of jobs you developed?
What are the primary usages of datastage tool?
How many Key we can define in remove duplicate stage?
What is difference between server jobs & parallel jobs?
How do you start developing a datastage project?
Can you implement SCD2 using join, transformer and funnel stage?
What is a folder? Difference types of stages?
How to implement complex jobs in data stage?
How to read multiple files using a single datastage job if files have the same metadata?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
