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 is deeup in unique only?
what is the difference between .dbc and .cfg file?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
Can any body give the PDL with example?
How you can delete an object from a tag ? How to use in abinitio graph?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
How to calculate total memory used my a graph?
Difference between private project parameters ,public project parameters and common project parameters?
what is meant by fancing in abinitio ?
EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer
What do you understand by local lookup?