How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
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
sed,awk,head
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what is repositery?
How and where you used hash file?
Could anyone give brief explanation bout datastage admin
On which interface you will be working as a developer?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Demonstrate experience in maintaining quality process standards?
What are the components of datastage?
Differentiate between validated and Compiled in the Datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
How do u convert the columns to rows in datastage?
To see hidden files in LINIX?
Why do you need stage variables?
Where do the datastage jobs get stored?