Interested to Buy Any Domain ? << Click Here >> for more details...
How to Improve Performance of graphs in Ab initio?
- 2 Answers
- 29729 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
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
What is the architecture of abinitio?
What is the difference between sandbox and EME?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Explain data flow graph with an example?
What is $mpjret?
can we perform checkin and checkout through sandbox?
What are “business rules” in ab initio business rules environment (bre)?
Why is data processing considered beneficial?
Have you used rollup component? Describe how.
i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?
Give one reason when you need to consider multiple data processing?
When we should use 'jobid' for commit table (Output table component??
Mention what is rollup component?
Mention some file extensions which are used in abinitio?
