How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
- 7 Answers
- 27795 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / guest
Frist using Sortstage sort the records based on sal column
for desc order and Each record unqiely identify using
surogatekey after that filterstage filter the first record
based on sur column and drag and drop only in sal column
in the output.Then We get the Max sal
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do you register plug-ins?
What are the different plug-ins stages used in your projects?
Can you explain link buffering?
Give an idea of system variables.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is a ds designer?
What is a quality stage in datastage tool?
What is the command line function to import and export the ds jobs?
What is a merge?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between informatica and datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
explain about citrix scheduling tool in datastage
