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 ? | 24 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of having stored procedures in a data-based?
What is the function you would use to transfer a string into a decimal?
How to create a repository in abinitio for stand-alone system(local nt)?
What is sandbox?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What metadata importer can do in ab initio?
How to create repository in abinitio for stand alone system(local nt)?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
Why might the optimizer use a table scan when an index is available?
What is the difference between dml expression and xfr expression?
What is the difference between check point and phase?
Explain the methods to improve performance of a graph?
What information is provided by .dbc file extension for connecting to the database?
What is the use of the co> operating system in ab initio?
How co> operating system natively processes the data?