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
Why might the optimizer use a table scan when an index is available?
The methods to improve performance of a graph?
Explain the ab initio etl tool in high level?
What information is provided by .dbc file extension for connecting to the database?
What kind of layouts does abinitio support?
Mention how can you connect eme to abinitio server?
Why might you create a stored procedure with the with recompile option?
Code check-in and check-out commands in AbInitio
Define ramp limit in ab initio?
What is air-project parameter ?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What is data encoding?
What are the benefits of data processing according to you?
What is de-partition in abinitio?
what is the project environment(for each project the environment is same or different to different project)?