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
Tell us about the architecture of abinitio.
What is the purpose of having stored procedures in a data-based?
What are the factors on which storage of data depends?
What kind of layouts does abinitio support?
What do you mean by the overflow errors?
List out the file extensions used in abinitio?
What is the difference between dml expression and xfr expression?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
Explain what is de-partition in abinitio?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Where $mpjret is used in ab-initio?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
What are the different types of parallelism used in abinitio?
How scientific data processing is different from commercial data processing?