Answer Posted / mahendra garewal

Hi,

Performance of graphs can be improved by employing the
following methods.
1:use data parallelism(but efficienty).
2:try to use less no of phases in graphs.
3:use component parallelism.
4:use component folding.
5:always use the oracle tuned query inside the input table
component this will give huge performance improvement.
6:Try to use as less as possible the components which does
not allows the pipeline parallelism.
7:Do not use huge lookups.
8:if data is not huge always use in memory sort option.

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

1391

---

Difference between output_index and output_indexes in reformat

1240

---

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1423

---

Explain the ab initio etl tool in high level?

1089

---

What is publickey and private key?what is the use of this two keys?

2844

---

Explain PDL with an example?

1264

---

What does it mean by the term 'sort component'?

1056

---

What is the function you would use to transfer a string into a decimal?

1158

---

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

942

---

Explain the methods to improve performance of a graph?

1069

---

Why might the optimizer use a table scan when an index is available?

2259

---

What do you understand by overflow errors?

1170

---

Mention some file extensions which are used in abinitio?

1078

---

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

996

---

What does edp stand for?

1112

---