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
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what is ods (operation data source)?
How did you plan your Data ware house project?
Who needs data warehousing?
What are diagrams?
What is the difference between power center and power mart?
What is the very basic difference between data warehouse and operational databases?
What is a data profile?
What are cluster analysis in data warehousing?
What is cfapplication tag?
How can you implement many relations in star schema model?
Tell me what is degree of a relation?
What is your spectra photometer working principles?
What are vaious etl tools in the market?
Difference between e-r modeling and dimentional modeling?