How can you find the 2nd Highest salary in a file department wise in abinitio?
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
What are the various types of layout supported by abinitio?
Explain how abinitio eme is segregated?
What are “business rules” in ab initio business rules environment (bre)?
Explain the difference between the truncate and delete commands?
Mention what is rollup component?
What is the ab initio business rules environment (bre)?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What is a data processing cycle and what is its significance?
What kind of layouts does abinitio support?
How can you export a component’s internal parameters ?
can we perform checkin and checkout through sandbox?
How many components in your most complicated graph?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Explain what is sort component in abinitio?
What do you know about abinitio?