Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the methods to improve the performance of a graph?
- 1 Answers
- 2852 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 the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?
What exactly do you know about the typical data analysis?
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?
what is decoding & what is NVL?
How to create a repository in abinitio for stand-alone system(local nt)?
what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?
Why might the optimizer use a table scan when an index is available?
11. What is the use of allocate()?
Difference between informatica vs ab initio?
what is the difference between .dbc and .cfg file?
How to move or copy the project parameter or project object to my sandbox?
Can anyone give me an exaple of realtime start script in the graph?
Teradata 
