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
Difference between cold fusion mx 6 and cold fusion mx 7?
What is difference between model & package?
Is there any default username & pwd for bo designer & supervisor?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Why null values are mapped as 0 in fact tables?
Explain what is a three tier data warehouse?
I know of using applysimple, but there are other ways too?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
Where do we use semi and non additive facts?
Explain what are necessary tasks to install reportnet software?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
How can you clear the cache?
Explain the difference between oltp and olap?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
what are the different views that are considered when building an object-oriented software system?