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
- 30070 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
what is the use of skid in reporting?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Explain how a source file is populated?
State the difference between an operational datastage and a data warehouse?
What is the purpose of pivot stage?
What are sequencers?
How do y read Sequential file from job control?
What could be a data source system?
what are the errors,warnings in datastage
Difference between in process and inter process?
What is meta stage?
How to RD using transformer?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the project in datastage?
