Answer Posted / murali krishna udayagiri

Yes Vital is correct. This can be acheived using SCAN
component with only one variable.

1.Input_file
2.Sort with in group (dno asc,sal desc)
3.scan
###############################################
type temporary_type=record
integer(4) temp1;end;
temp :: initialize(in) =
begin
temp.temp1::0;
end;

out :: scan(temp, in) =
begin
out.temp1 :: temp.temp1 + 1;
end;

out :: finalize(temp, in) =
begin
out.sal:: in.sal;
out.dno :: in.dno;
out.temp1 :: temp.temp1;
end;
out :: output_select(out) =
begin
out::out.temp1 == 2;
end;
###############################################
4.Output_file

Thanks,
Murali Udayagiri
Mail id: udayagiri.murali@gmail.com

Describe the grant/revoke ddl facility and how it is implemented?

1207

---

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1137

---

What do you mean by data sorting?

1275

---

How to compare two dmls in abinitio

1882

---

Describe in detail about lookup?

1128

---

How co>operating system integrates with legacy codes?

1245

---

What information is provided by .dbc file extension for connecting to the database?

1222

---

Tell us about the architecture of abinitio.

1150

---

What exactly do you know about the typical data analysis?

1154

---

Mention what is abinitio?

1045

---

How co> operating system natively processes the data?

1141

---

Can you explain the co>operating system’s processing model?

1156

---

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

1477

---

Hi friends, what are the new features in abinito3.0?

2844

---

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

1482

---