How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 42540 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / nikhil sali
We can use Scan.
1) First sort your data with 2 keys dept,salary description
2) In scan create one parameter say seq nbr and initialize it with 0.
3) in scan method increment it with 1
4) this will create rank in each group of dept
5) in output select method - select record where seq_nbr = 2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain about ab initio’s dependency analysis?
Explain what is sandbox?
Mention what the difference between “look-up” file and “look is up” in abinitio?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What does de-partition mean in abinitio?
What are the benefits of data analyzing?
State the relation between EME, GDE and Co-operating system?
What is is a data flow graph?
Have you used the rollup component? Describe how?
What are the functions of the replicate and dedup component?
How do you improve the performance of a graph?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
How to move or copy the project parameter or project object to my sandbox?
How can I run the 2 gui merge files?
How you can run a graph infinitely in ab initio?
