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
- 47369 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
Difference between informatica vs ab initio?
What is the core of co> operating system?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What are the operations that support avoiding duplicate record?
Mention what information does a .dbc file extension provides to connect to the database?
How do you truncate a table?
What are the factors on which storage of data depends?
Explain what is sort component in abinitio?
What are the benefits of data analyzing?
What are differences between different versions of co-op?
Can you explain the performance and scalability of co> operating system?
how to insert/update a csv file by comparing it with another csv file?
How does the bre work with the co>operating system?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Runtime behavior of Normalize and Reformat
