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 |
What is mean by aggregate aware?
How to answer the question how many fakt table in your datawarehouse and what size it have?
how much memory space occupied real time project (roughly)?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Could any one explain me how to create cascading prompts?
Explain Process flow in data warehouse??
What are data validation strategies for data mart validation after loading process?
What are the advantages of raid 1, 1/0, and
What is subject area?
What is a Data Cube?
What are steps we have to follow in designing the userfriendly universe?
Explain what are the different types of data warehousing?