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

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

713


Explain what is ods (operation data source)?

741


How did you plan your Data ware house project?

1996


Who needs data warehousing?

764


What are diagrams?

819


What is the difference between power center and power mart?

789


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

654


What is a data profile?

762


What are cluster analysis in data warehousing?

810


What is cfapplication tag?

758


How can you implement many relations in star schema model?

757


Tell me what is degree of a relation?

722


What is your spectra photometer working principles?

768


What are vaious etl tools in the market?

757


Difference between e-r modeling and dimentional modeling?

680