How can you find the 2nd Highest salary in a file department wise in abinitio?
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 is m_dump?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Can you explain data flow graph with an example?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
Name the different type of processing based on the steps that you know about?
Mention what dedup-component and replicate component does?
What the difference between “look-up” file and “look is up” in abinitio?
What is sandbox?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
Explain how abinitio eme is segregated?
How can I run the 2 gui merge files?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
what is the project environment(for each project the environment is same or different to different project)?
Can you explain the performance and scalability of co> operating system?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?