Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 2969 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 |
what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.
Mention what are the different types of parallelism used in abinitio?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
Mention what is the syntax for m_dump in abinitio?
what i the difference between the flows of 3 paralellisms
Can you use scan to generate sequence number ? How to use in abinitio graph?
Give one reason when you need to consider multiple data processing?
. What is flow buffering ? How it reduces the chances of having deadlock ?
How co>operating system integrates with legacy codes?
) How can you count the total no .of records in the specified partition in the Multifile?
How do you add default rules in transformer?
How to Improve Performance of graphs in Ab initio?
Teradata 
