Explain the methods to improve the performance of a graph?
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 |
. How can you run a graph continuously without using continuous components ?
Difference between private project parameters ,public project parameters and common project parameters?
What is meant by Co > Operating system and why it is special for Ab-initio ?
What are the prioritized Rules in as Transform function
How do you add default rules in the transformer?
What is the DynamicScriptGeneration and what is the Use?
Explain what is de-partition in abinitio?
explain checkin and checkout?
To which project that prefix will set is to private project or public project or both?how and where to set?
How to create repository in abinitio for stand alone system(local nt)?
Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?