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
- 30095 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
sed,awk,head
What are routines in datastage? Enlist various types of routines.
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the various kinds of containers available in datastage?
What can we do with datastage director?
root tree will find which is server job and which is parallel job?
Can we use target hash file as a lookup ?
how many rows sorted in sort stage by default in server jobs
Why do you need stage variables?
how to add a new records into source?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Define repository tables in datastage?
What are the main features of datastage?
Define meta stage?
What are the functionalities of link collector?
