Explain the methods to improve the performance of a graph?
- 1 Answers
- 2473 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 |
Difference between Force_error & Force_abort?
Can you use scan to generate sequence number ? How to use in abinitio graph?
What is meant by Co > Operating system and why it is special for Ab-initio ?
What is the difference between formal and export parameter? Export at what secenario we are going to use?
Can you read multiple input files using one input file component ?(same DML)
How to migrate the code FROM development to QA and QA to production?
What is abinitio?
What is the ab initio business rules environment (bre)?
What is the diff between abinitiorc and .abinitiorc files ?
What is sandbox?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
Mention some file extensions which are used in abinitio?
Teradata 
