How to Improve Performance of graphs in Ab initio?

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.

Is This Answer Correct ?    15 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a rollup component?

622


What the difference between “look-up” file and “look is up” in abinitio?

814


Difference between output_index and output_indexes in reformat

747


State the relation between EME, GDE and Co-operating system?

666


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

606






Have you used rollup component? Describe how.

650


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

594


How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

644


What a local lookup is?

597


What is broadcasting and replicate?

693


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

586


What do you mean by a transaction file and how it is different from that of a sort file?

623


Is data warehousing different from data mining?

624


What are the key elements of a data processing system?

683


What is m_dump?

726