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 the main difference between schema in rdbms and schemas in datawarehouse?
Explain the importance of data warehouse?
Explain what are the mapping paramaters and maping variables?
What is hash partition?
What are the different problems that ?Data mining? can solve?
What is surrogate key? Where we use it explain with example?
What are the main steps to build the data warehouse?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
Explain the main differences between star and snowflake schema?
What is query panel?
Ist the schema that a data warehouse system can implements.
What is operational data store (ods)?