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.

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

1144

---

What does de-partition mean in abinitio?

1279

---

Explain what is de-partition in abinitio?

1345

---

How to run a graph infinitely?

1121

---

How to create a repository in abinitio for stand-alone system(local nt)?

1121

---

How transaction file different from that of a sort file?

1416

---

When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?

2443

---

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4001

---

What are “business rules” in ab initio business rules environment (bre)?

2023

---

Mention some file extensions which are used in abinitio?

1120

---

Difference between output_index and output_indexes in reformat

1296

---

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?

1264

---

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1131

---

What exactly do you know about the typical data analysis?

1105

---

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1748

---