How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 45154 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 is a deadlock and how it occurs?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What do you mean by the overflow errors?
Mention some file extensions which are used in abinitio?
What is publickey and private key?what is the use of this two keys?
What do you mean by the term data warehousing?
What do you mean by the term data warehousing? Is it different from data mining?
What is the difference between dml expression and xfr expression?
What is the difference between check point and phase?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
What the difference between “look-up” file and “look is up” in abinitio?
What are the various types of layout supported by abinitio?
What are the different types of parallelism in ab initio?
What are the kinds of layouts does ab initio supports?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
