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
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Is the value of staging variable stored temporarily or permanently?
Can you highlight the main features of ibm infosphere information server?
Describe the architecture of datastage?
Can you define merge?
What are some different alternative commands associated with "dsjob"?
How do y read Sequential file from job control?
What is the difference between operational data stage (ods) and data warehouse?
How to read the length of word in unix?
How to Remove Duplicate using SQL?
What is the importance of the exception activity in datastage?
what is the use of surogate key in datastage
What are stage variables, derivations and constants?
describe the Steps to confiure a Qlogic switch
What is job control?