Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 3048 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
Can anyone give me an example of realtime start script in the graph?
What is common among data validity and data integrity?
How to create a repository in abinitio for stand-alone system(local nt)?
How can I run the 2 gui merge files?
How can you import XML repositories exported from different tools like ODI
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa
What do you understand by overflow errors?
Have you used rollup component? Describe how.
What is the purpose of having stored procedures in a data-based?
What is the use of the co> operating system in ab initio?
Describe in detail about lookup?
Can anyone give me an exaple of realtime start script in the graph?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?
