Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4466 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 are fundamental stages of data warehousing?
How do you define data block size?
Explain Process flow in data warehouse??
List any five applications of data warehouse.
What is data cleaning? How can we do that?
Explain what does level of granularity of a fact table signify?
Explain is fact table?
Explain functional dependency?
What is cost benefit analysis (cba)?
What is the "junk dimension"? Give with examples?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Teradata 
