how do you use commit frequencies? how does it affect
loading performance?
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 |
Explain ddl (data definition language)?
Data WareHousing course in noida
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
What is Molap and Rolap? What is Diff between Them?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
How do you setup Lo-cockpit?
What is a data profile?
Which one among Star and snowflake schemas will occupy more space?
What are snapshots? What are materialized views & where do we use them?
Compare cold fusion with other programming languages?
What are CUBES?