How can we increase the loading performance of oracle table in AbInitio?
- 1 Answers
- 1266 Views
- I also Faced
- E-Mail Answers
Answer / Ravindra Kumar Upadhyay
To increase the loading performance of an Oracle table in Abinitio, you can optimize your data loads by using bulk updates when possible, minimizing the number of committed transactions, and enabling fast refresh for materialized views. Additionally, properly indexing the tables can help improve query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the significance of record required indicator of Join component ? How to use in abinitio graph?
Describe step by step the process of creating tag and savefile for migration
Explain the methods to improve performance of a graph?
Hi friends, I have 100 records in my input file, if i run first,the first 10 records are stored into the output and if i run second time next 10 records stored into the output file like that please let me know the answer Thanks, krishna
What is the use of the co> operating system in ab initio?
Name the different type of processing based on the steps that you know about?
Can you read multiple input files using one input file component ? (Same DML) How to use in abinitio graph?
What does edp stand for?
Why creation of temporary files depends on the value of MAX CORE
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Describe what the SQL Server tempdb and tlog files are used for?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
Teradata 
