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

How abinitio eme is segregated?

1044


What do you mean by data sorting?

864


What is data mapping and data modelling?

1238


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

801


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

2609


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

873


What is de-partition in abinitio?

1124


Where $mpjret is used in ab-initio?

882


Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?

909


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

960


Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1076


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

1070


What are the different forms of output that can be obtained after processing of data?

992


difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2542


Do you think effective communication is necessary for data processing?

965