Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4631 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 |
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Is there any difference in testing database and data ware housing?
Compare ?Data mining? and ?Data Warehousing??
Explain what are the mapping paramaters and maping variables?
What are the different models used in cluster analysis?
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
What is the difference between a W/H and an OLTP application?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is ods (operation data source)?
What are partition points?
Teradata 
