Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 2983 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 |
How is the partitioning with key different from round robin partition?
Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna
What is the diff between abinitiorc and .abinitiorc files ?
Explain how you can run a graph infinitely in ab initio?
What is the Reformat Layout?(i/p ->Reformat->o/p)
What are Cartesian joins?
i need help from u. i want to learn abinitio. please provide pdfs or material or books.
What do you mean by the term data warehousing? Is it different from data mining?
How you can test a dbc file ?
How to run the graph without GDE?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
What are the six data process products of ab initio (architecture of ab initio)?
Teradata 
