Answer / radhakrishna shanbhag

1. You may convert the serial file to multifile system using a partition by key, if it is a serial file.
2. You may filter out all the records from the file that are unwanted for the process. Elimination of records helps the cause.
3. If there are joins with any tables/files, try to use look up files for smaller tables/files.
Also you should use the larger file as the driver port for joins with bigger tables/files.
4. Use in memory sort for smaller file joins.
5. By any chance if you are unloading from a table, you may use order by in the SQL which eliminates use of Sort component in the graph.
I hope these helps. Please correct me if I am wrong.

Mention what is the role of co-operating system in abinitio?

1 Answers  

---

How to connect mainframe to Abinitio?

1 Answers   CTS,

---

Code check-in and check-out commands in AbInitio

0 Answers  

---

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

0 Answers  

---

Order of Evaluation of Parameters

2 Answers  

---

Explain the methods to improve the performance of a graph?

1 Answers  

---

What is meta programming ? Can you generate xfr dynamically? How to use in abinitio graph?

1 Answers   IBM, TCL,

---

Can any body give the PDL with example?

1 Answers   Cap Gemini,

---

What is a data processing cycle and what is its significance?

0 Answers  

---

What is dependent parameter ?

1 Answers   HCL,

---

Have you used the rollup component? Describe how?

0 Answers  

---

How does the bre work with the co>operating system?

0 Answers  

---