how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 3997 Views
- I also Faced
- E-Mail Answers
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
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is meant by metadata in context of a data warehouse and how it is important?
I know of using applysimple, but there are other ways too?
Explain the difference between view and materialized view?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain what are the advantages and disadvantages of reporting directly against the database?
What is your spectra photometer working principles?
How to pivot row data using informatica?
Explain what is a three tier data warehouse?
Explain why fact table is in normal form?
What are the main steps to build the data warehouse?
Explain what is a cube in data warehousing concept?
How many project sources we can create in metadata?
Explain is olap databases are called decision support system true/false?
Define Data Warehousing?
