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
Name the different type of processing based on the steps that you know about?
What is sandbox?
Have you ever encountered an error called “depth not equal”?
State the working process of decimal_strip function?
What the difference between “look-up” file and “look is up” in abinitio?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
The methods to improve performance of a graph?
How to add default rules in transformer?
Mention what information does a .dbc file extension provides to connect to the database?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
What is the difference between look-up file and look-up, with a relevant example?
Explain about ab initio’s dependency analysis?
What is the syntax for m_dump in abinitio?
List out some of the air commands used in abintio?
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?