How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 42640 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
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Mention some file extensions which are used in abinitio?
What is is a data flow graph?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What exactly do you know about the typical data analysis?
How abinitio eme is segregated?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
Mention what dedup-component and replicate component does?
What is ab initio enterprise meta>environment (eme)?
How co> operating system natively processes the data?
What is the syntax for m_dump in abinitio?
What is the difference between look-up file and look-up, with a relevant example?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Mention some ways for improving performance of a graph?
Explain PDL with an example?
