Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 3053 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is a rollup component?
What are the various types of layout supported by abinitio?
How to run a graph infinitely?
What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.
What is sandbox?
What exactly do you understand with the term data processing and businesses can trust this approach?
What metadata importer can do in ab initio?
What does edp stand for?
hello, tell me the function which removes spaces from decimal field?
What is sort component in abinitio?
Mention some file extensions which are used in abinitio?
Mention some ways for improving performance of a graph?
Teradata 
