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
- 30391 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
How do you import and export the datastage jobs?
What are the some differences between 7.x and 8.x version of datastage?
Define project in datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
How to convert RGB Value to Hexadecimal values in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
why do u need the IOS upgradation in a FC switch
How to clean the datastage repository?
What is the purpose of pivot stage?
Why do we use link partitioner and link collector in datastage?
What a datastage macro?
Whats difference betweeen operational data stage (ods) and data warehouse?
what is the difference between == and eq in UNIX shell scripting?
What is oci?
