Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4467 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
How to create prompts in report net?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain vldb?
Explain what are slowly changing dimensions?
What we will do with the universe for faster process?
Compare aggregates and data marts
What is the metadata extension?
How many project sources we can create in metadata?
How to know the time taken for particular report execution?
Give some difference between oltp and olap.
Explain what is the difference between power center & power mart?
What are the key features of chameleon that separates it from other algorithms?
What are the fundamental elements of the data warehouse?
What is many-to-many dimensional model in datawarehousing ?
