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

What is the max core of a component?

1097

---

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

1140

---

What are differences between different versions of co-op?

1208

---

What are the differences between informatica and abinitio?

1213

---

Give one reason when you need to consider multiple data processing?

1174

---

Define ramp limit in ab initio?

1285

---

Have you used rollup component? Describe how.

1071

---

Explain the ab initio etl tool in high level?

1133

---

How is the partitioning with key different from round robin partition?

1218

---

How to add default rules in the transformer?

1229

---

What are the co> operating system’s assorted library of integrated components?

1118

---

What will be the skew for, input file->partition by key-> partition by round robin->output file

969

---

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1253

---

How do you truncate a table?

1173

---

What is de-partition in abinitio?

1363

---