Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 3054 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the ab initio business rules environment (bre)?
What are the differences between informatica and abinitio?
What is rollup component?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
Can anyone give me an example of realtime start script in the graph?
What will be the skew for, input file->partition by key-> partition by round robin->output file
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
What do you know about abinitio?
What the difference between “look-up” file and “look is up” in abinitio?
What dedup-component and replicate component does?
What are the benefits of data processing according to you?
When we should use 'jobid' for commit table (Output table component??
What are the kinds of layouts does ab initio supports?
How can I run the 2 gui merge files?
Have you worked with packages?
