Interested to Buy Any Domain ? << Click Here >> for more details...
how do you use commit frequencies? how does it affect
loading performance?
- 1 Answers
- 4475 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Suggest a good author for hyperion in data warehousing?
How can you implement many relations in star schema model?
Briefly state different between data ware house & data mart?
What are vaious etl tools in the market?
What is surrogate key? Where we use it explain with example?
What is a full backup?
Explain swot analysis?
Explain what are the steps to build the data warehouse?
What is scd1 , scd2 , scd3?
what is an use case?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain where do we use semi and non additive facts?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain a mapping, session, worklet, workflow, mapplet?
