Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11745 Views
- I also Faced
- E-Mail Answers
Answer Posted / shrihari
data warehouse is often use denormalized schema to optimize
query perfomance.
OLTP sytem often use fully normalized schema to optimize
update, insert, delete perfomance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of incremental aggregation? Explain me in brief with an example?
Which component has onread method and what it is used for?
Explain what are non-additive facts?
What is the difference between view filter and report filter?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
explain about dirty dimension?
Explain what is the difference between a primary and secondary actor in use case modeling?
Explain meta data?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What are the advantages of cold fusion?
Explain what are the different types of data warehousing?
What is "method/1"?
Explain what is the difference between olap and datawarehosue?
