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
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|
Answer / mahendra garewal
Performance of graphs can be improved by employing the
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|
What is difference between force_error & force_abort? How to use in abinitio graph?
What are the functions of the replicate and dedup component?
What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.
What are the Graph parameter?
What is the max core of a component?
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?
What do you know about partition and also tell us about partition components in abinitio?
Have you ever encountered an error called “depth not equal”?
How you can delete an object from EME data store ? How to use in abinitio graph?
Layout - L1*, L1 - What is the difference ? How to use in abinitio graph?
What the difference between “look-up” file and “look is up” in abinitio?
Mention how can you connect eme to abinitio server?