How can you find the 2nd Highest salary in a file department wise in abinitio?
- 9 Answers
- 44007 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / ravi
we can do this with scan comp
exp::i/p folloed by sort folloed by scan and o/p
ip record
id,dept_name,sal
in sort keep key fields as (dept_name,sal descending)
now in scan write this T/f in parametres
type temporary_type
record
decimal("")secno;
end;
temp::initialize(in)=
begin
temt.secno::0;
end;
temp::scan(temp,in)=
out::finalize(temp,in)=
begin
out.in::in.id;
out.ddept_name::in.dept_name;
out.secno::temp.secno;
out.sal::in.sal;
end;
out::out_select(out)=
begin
out::out.secno==2
end;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How data is processed and what are the fundamentals of this approach?
What are the Types of parallelism in detail?
Why do you think data processing is important?
What are the benefits of data analyzing?
Why might the optimizer use a table scan when an index is available?
What are the features of ab initio?
What are the operations that support avoiding duplicate record?
How to create a repository in abinitio for stand-alone system(local nt)?
What is MAX CORE of a component?
How do you add default rules in transformer?
Mention some ways for improving performance of a graph?
What would be the next step after collecting the data?
What is the difference between check point and phase?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
