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
- 47410 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 do you know about partition and also tell us about partition components in abinitio?
Explain what is sandbox?
What is the core of co> operating system?
How can you import XML repositories exported from different tools like ODI
What is the role of co-operating system in abinitio?
Mention some file extensions which are used in abinitio?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
What is the importance of eme in abinitio?
What is the difference between check point and phase?
State the working process of decimal_strip function?
Describe the grant/revoke ddl facility and how it is implemented?
Explain the difference between the truncate and delete commands?
What is air-project parameter ?
How scientific data processing is different from commercial data processing?
Have you used the rollup component? Describe how?
