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


Please Help Members By Posting Answers For Below Questions

What is the very basic difference between data warehouse and operational databases?

680


What is many-to-many dimensional model in datawarehousing ?

727


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

775


What is type 2 version dimension?

775


What is Sequence clustering algorithm?

1789


Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2107


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

779


Explain the difference between keylokup and joiner?

707


Explain about core dimension, balanced dimension, and dirty dimension?

777


What are the advantages of raid 1, 1/0, and

769


What are the key features of chameleon that separates it from other algorithms?

910


What is difference between model & package?

782


Compare cold fusion with other programming languages?

783


Explain what is the difference between stop and abort?

787


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?

812