Explain the methods to improve the performance of a graph?
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 |
In abinitio, what types of parallelism are used?
Have you used the rollup component? Describe how?
How to move data from developement to testing and testing to production?
1 Answers BitWise, CTS, Satyam, Wipro,
How to migrate the code FROM development to QA and QA to production?
Explain the methods to improve performance of a graph?
what is the difference between i)public ii)private iii)common and client projects?
How can I run the 2 gui merge files?
In MFS i developer developed 2-way, but supporters r supporting 4-way on same records how is possible?
What parallelisms does Abinitio support?
What is the role of co-operating system in abinitio?
Describe what the SQL Server tempdb and tlog files are used for?
What is the difference between look-up file and look-up, with a relevant example?