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 |
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
What is $mpjret?
Explain what is the architecture of abinitio?
What do you mean by the overflow errors?
What is the best way of creating huge test feeds ? How to use in abinitio graph?
What is max core value ? what is the use of it?
2 Answers JPMorgan Chase, Wipro,
Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?
what is macro?At what situation we have to face?
Mention what the difference between “look-up” file and “look is up” in abinitio?
what is the difference between .dbc and .cfg file?
What kind of layouts does abinitio support?
What is the difference between rollup and scan?