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


Please Help Members By Posting Answers For Below Questions

Why might the optimizer use a table scan when an index is available?

2040


The methods to improve performance of a graph?

819


Explain the ab initio etl tool in high level?

884


What information is provided by .dbc file extension for connecting to the database?

911


What kind of layouts does abinitio support?

909


Mention how can you connect eme to abinitio server?

1138


Why might you create a stored procedure with the with recompile option?

855


Code check-in and check-out commands in AbInitio

3907


Define ramp limit in ab initio?

991


What is air-project parameter ?

1956


Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

801


What is data encoding?

966


What are the benefits of data processing according to you?

928


What is de-partition in abinitio?

1124


what is the project environment(for each project the environment is same or different to different project)?

1919