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
Explain datastage architecture?
How rejected rows are managed in datastage?
What are the areas of application?
How many Key we can define in remove duplicate stage?
What are the different options associated with dsjob command?
Define orabulk and bcp stages?
How to find value from a column in a dataset?
Describe the main features of datastage?
What are transforms and what is the differenece between routines and transforms?
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?
How do you register plug-ins?
How do you generate sequence number in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Which commands are used to import and export the datastage jobs?
Define Routines and their types?