How to get max salary of an organization using data stage
stages...........
can any body help me plz.......
- 7 Answers
- 27856 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
Describe link sort?
Which warehouse using in your datawarehouse
If you want to use a same piece of code in different jobs, how will you achieve this?
Can you highlight the main features of ibm infosphere information server?
Name the different types of Lookups in Datastage?
What are the benefits of datastage?
What are the processing stages?
how do u catch bad rows from OCI stage? And what CLI stands for?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is use Array size in datastage
What are stage variables, derivations and constants?
Can you explain kafka connector?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the different common services in datastage?
