rollup would reduce the number of records how could you get 2nd highest af

How can you find the 2nd Highest salary in a file department wise in abinitio?

Question Posted / vital_parsley

Answer Posted / vital_parsley

rollup would reduce the number of records how could you get
2nd highest after that ?

I think Scan can work with 2 temp vars.

Is This Answer Correct ?

13 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning with key / hash and round robin?

1386

What are the different types of partition components in abinitio?

1356

Why might you create a stored procedure with the with recompile option?

1133

What is $mpjret?

1155

What are the functions of the replicate and dedup component?

1094

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1128

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

986

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?

989

What is the ab initio business rules environment (bre)?

1175

How can I run the 2 gui merge files?

1185

What is data encoding?

1264

What are the operations that support avoiding duplicate record?

1451

What are the facts that can compromise data integrity?

1150

What are the six data process products of ab initio (architecture of ab initio)?

1116

What is sort component in abinitio?

1236