how do you use commit frequencies? how does it affect
loading performance?
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 the very basic difference between data warehouse and operational databases?
What is many-to-many dimensional model in datawarehousing ?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What is type 2 version dimension?
What is Sequence clustering algorithm?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Explain the difference between keylokup and joiner?
Explain about core dimension, balanced dimension, and dirty dimension?
What are the advantages of raid 1, 1/0, and
What are the key features of chameleon that separates it from other algorithms?
What is difference between model & package?
Compare cold fusion with other programming languages?
Explain what is the difference between stop and abort?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?