Explain the methods to improve the performance of a graph?
- 1 Answers
- 3114 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 are the reasons for which business can trust the approach of data processing?
what i the difference between the flows of 3 paralellisms
How you can run a graph infinitely in ab initio?
What are the various types of layout supported by abinitio?
how can you convert 3 way to 7way partitioning in abinitio?
Is data warehousing different from data mining?
What is $mpjret? Where it is used in ab-initio?
What is the difference between partitioning with key and round robin?
Describe what the SQL Server tempdb and tlog files are used for?
what is the difference between .dbc and .cfg file?
What is the importance of eme in abinitio?
Do we really work with ACTUALDATA in development phase.
Teradata 
