How to Improve Performance of graphs in Ab initio?

Answers were Sorted based on User's Feedback

How to Improve Performance of graphs in Ab initio?..

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
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
5> If component have In memory: Input need not be sorted
option selected, use the MAX_CORE parameter value
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 ?    21 Yes 1 No

How to Improve Performance of graphs in Ab initio?..

Answer / mahendra garewal


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 ?    14 Yes 1 No

Post New Answer

More Ab Initio Interview Questions

What is difference between force_error & force_abort? How to use in abinitio graph?

2 Answers   TCL, IBM,

What are the functions of the replicate and dedup component?

0 Answers  

What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.

1 Answers  

What are the Graph parameter?

0 Answers  

What is the max core of a component?

0 Answers  

We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?

4 Answers   IMS, TCS,

What do you know about partition and also tell us about partition components in abinitio?

0 Answers  

Have you ever encountered an error called “depth not equal”?

0 Answers  

How you can delete an object from EME data store ? How to use in abinitio graph?

1 Answers   TCL, IBM,

Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?

1 Answers   TCL, IBM,

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

0 Answers  

Mention how can you connect eme to abinitio server?

0 Answers