Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4632 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
What are the data marts?
Explain the different types of data warehousing?
What is hybrid slowly changing dimension?
What is Discrete and Continuous data in Data mining world?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
How to add a number to a macro variable?
What are the difference between snow flake and star schema?
Explain what is real time data-warehousing?
What we will do with the universe for faster process?
Explain hybrid slowly changing dimension?
What is a hash cluster?
Explain what are the various reporting tools in the market?
What is a cube in data warehousing concept?
What are the approaches used by optimizer during execution plan?
What does level of granularity of a fact table signify?
