how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 3996 Views
- I also Faced
- E-Mail Answers
Answer / ram
More commit intervals decreases the performance.
i.e for example if you r loading into a table from a source
table contains 10000 rows ,at commit the target table for
each 100 rows, the serves needs to commit 100 times if it
the commit interval is 10000 then it needs to commit only 1
time.
| Is This Answer Correct ? | 4 Yes | 1 No |
Database in use is oracle?
Explain what is ods (operation data source)?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
How to stop a batch?
How to performance tune reports?
What is the main difference between schema in rdbms and schemas in datawarehouse?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is ods (operation data source)?
What do you mean by static and local variable?
What is crass reference table?
What is the difference between narmal load and bulk load?
Define data warehouse?
Teradata 
