how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4171 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to load the time dimension?
What are data modeling and data mining?
Explain in simple terms, the concept of Data Mining.
what is parallel query?
what are different types of partitioning in oracle ?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Explain the importance of data warehouse?
What is staging area?
What is the difference between Datawarehouse and OLAP?
What is confirmed dimension?
What is the goal of optimizer?
Difference between cold fusion 5 and cold fusion mx 6?
Teradata 
