Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4548 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 |
ware house management system is used?
What is surrogate key? Where we use it? Explain with examples.
How can you communicate with web server (apache or iis) from coldfusion?
what is the difference between DSS and ODS ?
Explain difference between view and materialized view?
What is a view as it relates to system modeling?
Explain grouped cross tab?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
Explain clustering algorithm?
What is source qualifier?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain what is cost benefit analysis (cba)?
Teradata 
