Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve Performance of graphs in Ab initio?
- 2 Answers
- 29761 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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 ? | 26 Yes | 1 No |
Post New Answer View All Answers
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Within a cursor, how would you update fields on the row just fetched?
What is a rollup component? Explain about it.
How can you export a component’s internal parameters ?
What is the architecture of abinitio?
Difference between output_index and output_indexes in reformat
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
How do you improve the performance of a graph?
What is a partition?
What is sandbox?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Where $mpjret is used in ab-initio?
Why might the optimizer use a table scan when an index is available?
What are the fundamental blocks of co> operating system of ab initio?
