How can you find the 2nd Highest salary in a file department wise in abinitio?

Answer Posted / sridhar

when each group is having two 2nd higest values this logic
will not work.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define ramp limit in ab initio?

865


What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

837


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2403


How data is processed and what are the fundamentals of this approach?

746


What is the importance of eme in abinitio?

769






Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

697


What are the facts that can compromise data integrity?

743


How would you find out whether a sql query is using the indices you expect?

690


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

3654


What is the core of co> operating system?

722


Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

662


What is m_dump?

836


What is a rollup component? Explain about it.

773


What are the benefits of data analyzing?

771


List out some of the air commands used in abintio?

888