Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve Performance of graphs in Ab initio?
- 2 Answers
- 29876 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 26 Yes | 1 No |
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 ? | 15 Yes | 1 No |
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
Tell us about the architecture of abinitio.
What is the difference between formal and export parameter? Export at what secenario we are going to use?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
Difference between public and private projects and how to make private to public?
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
What is the importance of eme in abinitio?
What is EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.
Where $mpjret is used in ab-initio?
State the working process of decimal_strip function?
Teradata 
