How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
Answer Posted / nandhini
Create one dummy key and set the value as 1 for all input
columns and use remove duplicate stage. Here use this dummy
as key and use sorting, partitioning for dummy and company
columns & use sorting (descending) for salary column and in
properties tab, select duplicate to retain as last.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
whom do you report?
how to add a new records into source?
what is repositery?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to delete one row in target dataset
Can you highlight the main features of ibm infosphere information server?
What is difference between join, merge and lookup stage?
What is the differentiate between data file and descriptor file?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are some prerequisites for datastage?
What are the some differences between 7.x and 8.x version of datastage?
Notification Activity
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the functionalities of link partitioner?
Define project in datastage?