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

How to add default rules in transformer?

948


What are the benefits of data analyzing?

929


How you can run a graph infinitely in ab initio?

1161


I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

929


What is a deadlock and how it occurs?

907


Mention what is abinitio?

786


What is the difference between sandbox and EME?

992


What do you understand by a cartesian join?

898


How to compare two dmls in abinitio

1567


When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

883


What do you understand by local lookup?

884


Pdl with an example?

885


What is a local lookup?

961


What is abinitio?

933


Give one reason when you need to consider multiple data processing?

900