Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4555 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 is a data profile?
Explain me what is vldb?
How to create different types of templates?
What is pre-emptive and non-pre-emptive?
How to reduce warnings?
Explain the difference between data ware house & data mart?
Explain the different types of data warehousing?
Explain what are non-additive facts?
What is data warehosuing hierarchy?
Explain what is cost benefit analysis (cba)?
How to calculate fact table granularity?
How to eliminate duplicate rows from flat file?
How can we load the time dimension?
How many project sources we can create in metadata?
In document how to create metrics?
