How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
- 7 Answers
- 27922 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 schedule or monitoring the job?
what is the difference between == and eq in UNIX shell scripting?
whom do you report?
What are the different layers in the information server architecture?
What is "fatal error/rdbms code 3996" error?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the different plug-ins stages used in your projects?
What are some prerequisites for datastage?
How do you run datastage job from the command line?
Why fact table is in normal form?
Highlight the main features of datastage?
What are the job parameters?
what are the errors,warnings in datastage
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How a server job can be converted to a parallel job?
