Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 2851 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
Mention what information does a .dbc file extension provides to connect to the database?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Explain data flow graph with an example?
What are the various types of layout supported by abinitio?
How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Explain the difference between the truncate and delete commands?
How can I run the 2 gui merge files?
How does the bre work with the co>operating system?
What is the architecture of abinitio?
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?
Can you explain the co>operating system’s processing model?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
What are the benefits of data processing according to you?
What is a deadlock and how it occurs?
