How to Improve Performance of graphs in Ab initio?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
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)?
List the various vector functions used in ab initio with syntax.
What are the prioritized Rules in as Transform function
Explain the methods to improve the performance of a graph?
Broadcast and replicate does the similar work , what’s the diff then
What is a data processing cycle and what is its significance?
Need Ab-Initio Material - Harini
What do you mean by the overflow errors?
How can we RUN a graph in UNIX?
What is the difference between partitioning with key and round robin?
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
I installed AbInito in my PC.In components there is no "select" component.How can i get that component?and How we can create user defined components?