How to Improve Performance of graphs in Ab initio?
Answer Posted / 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 ? | 15 Yes | 1 No |
Post New Answer View All Answers
Define ramp limit in ab initio?
Mention some ways for improving performance of a graph?
How is the partitioning with key different from round robin partition?
Difference between informatica vs ab initio?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Explain about ab initio’s dependency analysis?
How do you improve the performance of a graph?
How does the bre work with the co>operating system?
What is $mpjret?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
What are the different forms of output that can be obtained after processing of data?
What do you understand by overflow errors?
What is a look-up?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?