How can you find the 2nd Highest salary in a file department wise in abinitio?
Answer Posted / vital_parsley
1)use a reformat.
2)Global variable which increments with every records only
if previous record is not equal to current record
3) output_select where sal == 2
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is the project environment(for each project the environment is same or different to different project)?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
How to compare two dmls in abinitio
You can ask about different vector functions. How to use in abinitio graph?
List out the file extensions used in abinitio?
What do you mean by a transaction file and how it is different from that of a sort file?
what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
Explain the methods to improve performance of a graph?
What are the key elements of a data processing system?
How can a graph be run infinitely?
Can you explain data flow graph with an example?
What is publickey and private key?what is the use of this two keys?
Define ramp limit in ab initio?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low