How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 44010 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / roshni
you can use roll up to calculate dept wise salary first and
then sort it with key as sal. create indexes using
next_in_sequence() and then filter out the 2nd record.
hope this helped!!
| Is This Answer Correct ? | 19 Yes | 11 No |
Post New Answer View All Answers
What are the differences between informatica and abinitio?
How can I run the 2 gui merge files?
What would be the next step after collecting the data?
Code check-in and check-out commands in AbInitio
What do you mean by data sorting?
What is broadcasting and replicate?
Explain batch processing in ab initio?
What is common among data validity and data integrity?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
How do you improve the performance of a graph?
What is the role of co-operating system in abinitio?
What is $mpjret?
How is the partitioning with key different from round robin partition?
What will be the skew for, input file->partition by key-> partition by round robin->output file
What is the core of co> operating system?
