Interested to Buy Any Domain ? << Click Here >> for more details...
How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 47687 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 differences between different versions of co-op?
What are the different types of parallelism used in abinitio?
What are the factors on which storage of data depends?
What does it mean by the term 'sort component'?
What is common among data validity and data integrity?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Within a cursor, how would you update fields on the row just fetched?
What metadata importer can do in ab initio?
How you can run a graph infinitely in ab initio?
What is the difference between sandbox and EME?
What is de-partition in abinitio?
How can I run the 2 gui merge files?
Give one reason when you need to consider multiple data processing?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
Hi friends, what are the new features in abinito3.0?
