Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4560 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 |
What should I have in mind when building olap solution from scratch?
Define data warehouse?
What are the types of dimensional modeling?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is defined as partial backup?
Explain me what is vldb?
What is the 4 + 1 view model as it relates to system modeling?
Why should we use data ware housing and how can you extract data for analysis with example?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
What is a star schema? Why does one design this way?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Teradata 
