Explain the methods to improve the performance of a graph?
Answer Posted / radhakrishna shanbhag
1. You may convert the serial file to multifile system using a partition by key, if it is a serial file.
2. You may filter out all the records from the file that are unwanted for the process. Elimination of records helps the cause.
3. If there are joins with any tables/files, try to use look up files for smaller tables/files.
Also you should use the larger file as the driver port for joins with bigger tables/files.
4. Use in memory sort for smaller file joins.
5. By any chance if you are unloading from a table, you may use order by in the SQL which eliminates use of Sort component in the graph.
I hope these helps. Please correct me if I am wrong.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a local lookup?
Where $mpjret is used in ab-initio?
What are “business rules” in ab initio business rules environment (bre)?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
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)?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
How to move or copy the project parameter or project object to my sandbox?
Do you know what a local lookup is?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
Name the different type of processing based on the steps that you know about?
What the difference between “look-up” file and “look is up” in abinitio?
What is is a data flow graph?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
Describe the evaluation of parameters order in ab initio?