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 use of catlog or catlogfile?
What are the reasons for which business can trust the approach of data processing?
What is abinitio?
State the relation between EME, GDE and Co-operating system?
How do you truncate a table?
Mention what is a partition and what are the different types of partition components in abinitio?
What is the difference between check point and phase?
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)?
Is data warehousing different from data mining?
What are the six data process products of ab initio (architecture of ab initio)?
Do you know what a local lookup is?
how to insert/update a csv file by comparing it with another csv file?
Within a cursor, how would you update fields on the row just fetched?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
How you can run a graph infinitely in ab initio?