Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4549 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is difference between query studio and report studio?
How to generate iqd file from framework manager?
What is static and local variable?
What is Discrete and Continuous data in Data mining world?
What is drilling across?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain the differences between normalizer and normalizer transformation?
What are the different types of schemas used in data warehousing?
Explain what is real time data-warehousing?
What is drill-through?
Fact table is in normalized or de-normalized form?
Explain what are non-additive facts in detail?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are fundamental stages of data warehousing?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
