Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve Performance of graphs in Ab initio?
- 2 Answers
- 29560 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
What is the importance of eme in abinitio?
How to add default rules in the transformer?
What is a local lookup?
Where $mpjret is used in ab-initio?
What is a look-up?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What is sandbox?
Have you worked with packages?
Explain what is sandbox?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
what is the project environment(for each project the environment is same or different to different project)?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What is m_dump?
How data is processed and what are the fundamentals of this approach?
Difference between informatica vs ab initio?
