How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / vital_parsley
rollup would reduce the number of records how could you get
2nd highest after that ?
I think Scan can work with 2 temp vars.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
How to move or copy the project parameter or project object to my sandbox?
what is the output when -1 is put in select_expr of FBE?
When we should use 'jobid' for commit table (Output table component??
What are the co> operating system’s assorted library of integrated components?
What do you mean by the term data warehousing?
What is conduct>it?
What are the steps to create a repository in ab initio?
What is sandbox?
What is the difference between sandbox and EME?
What is the syntax for m_dump in abinitio?
what is the project environment(for each project the environment is same or different to different project)?
What do you mean by the term data warehousing? Is it different from data mining?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
What is a rollup component? Explain about it.