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;

Explain how abinitio eme is segregated?

1480

---

Explain the methods to improve performance of a graph?

1102

---

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1129

---

What are the reasons for which business can trust the approach of data processing?

1174

---

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.

1365

---

What are the steps to create a repository in ab initio?

1238

---

Can anyone give me an example of realtime start script in the graph?

1168

---

Can you explain the performance and scalability of co> operating system?

1116

---

In abinitio, what types of parallelism are used?

1080

---

Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?

1085

---

What does de-partition mean in abinitio?

1264

---

What is local and formal parameter?

1388

---

Mention what information does a .dbc file extension provides to connect to the database?

1319

---

How can you import XML repositories exported from different tools like ODI

3547

---

What is the purpose of having stored procedures in a database?

1139

---