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
What are the different types of partition components in abinitio?
What is the ab initio business rules environment (bre)?
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
What is $mpjret?
Pdl with an example?
What is brodcasting and replicate?
What is the difference between dml expression and xfr expression?
Explain PDL with an example?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What are the functions of the replicate and dedup component?
What is a deadlock and how it occurs?
How many components in your most complicated graph?
How can a graph be run infinitely?
How to add default rules in transformer?
What information does a .dbc file extension provides to connect to the database?