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

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

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

Post New Answer

More Ab Initio Interview Questions

What is the difference between a scan component and a rollup component?

0 Answers  


) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers  


what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 Answers  


What is the core of co> operating system?

0 Answers  


What do you understand by local lookup?

0 Answers  






What is m_dump?

0 Answers  


What is data encoding?

0 Answers  


Describe what the SQL Server tempdb and tlog files are used for?

0 Answers  


Explain what is de-partition in abinitio?

0 Answers  


Pdl with an example?

0 Answers  


How data is processed and what are the fundamentals of this approach?

0 Answers  


What happens when we provide null key to sort, merge and pbks in Abinitio ?

0 Answers  






Categories