Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 2882 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 |
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?
You can ask about different vector functions. How to use in abinitio graph?
How to connect mainframe to Abinitio?
What is $mpjret? Where it is used in ab-initio?
What do you mean by data sorting?
The methods to improve performance of a graph?
What is the difference between reformat and redefine format?
Which component breaks the pipe line parallelism in graph?
How to load the data from an excel sheet to input file in a graph?
Explain the methods to improve the performance of a graph?
What is the architecture of abinitio?
what is the difference between ab_work_dir and .work
Teradata 
