Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4479 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 |
Where do we use semi and non additive facts?
I know of using applysimple, but there are other ways too?
How to create context?
what is the difference between MOLAP and ROLAP?
What are fact, dimension, and measure?
what is difference between drill & scope of analysis?
Explain what are the advantages data mining over traditional approaches?
What are the data types present in bo? What happens if we implement view in the designer n report?
Difference between PowerPlay transformer and power play reports?
Why should you put your data warehouse on a different system than your oltp system?
What is a real-time data warehouse?
What is the difference between er modeling and dimensional modeling?
Teradata 
