How to Improve Performance of graphs in Ab initio?
Answer Posted / ananya
There are many ways to improve the performance of the
graph. It also depends on a particular graph, the
components used in it.
In general the following tips can be used for improving
performance:
1> Try to use partitioning in the graph
2> try minimising the number of components
3> Maintain lookups for better effeciency
4> Components like join/ rollup should have the option
Input must be sorted, if they are placed after a sort
component.
5> If component have In memory: Input need not be sorted
option selected, use the MAX_CORE parameter value
efeciently.
6> Use phasing of a graph effeciently.
7> Ensure that all the graphs where RDBMS tables are used
as input, the join condition is on indexed columns.
8> Try to perform the sort or aggregation operation of data
in the source tables at the database server itself, instead
of using it in AbInitio.
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
What are the Graph parameter?
What is a rollup component?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What are the co> operating system’s assorted library of integrated components?
What a local lookup is?
What are the fundamental blocks of co> operating system of ab initio?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
Code check-in and check-out commands in AbInitio
What is the role of co-operating system in abinitio?
What is the difference between partitioning with key / hash and round robin?
What is brodcasting and replicate?
What are the different types of parallelism used in abinitio?
What metadata importer can do in ab initio?
Explain what is sandbox?
What is the difference between sandbox and EME?