Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11518 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
How are models actually derived?
What is critical column?
What is the difference between power center & power mart?
Explain the definition of normalized and denormalized view and what are the differences between them?
Why should you put your data warehouse on a different system than your oltp system?
What is Star Schema?
What are the main steps to build the data warehouse?
What is partitioning? What are the types of partitioning?
Why is business intelligence (bi) important in data warehousing?
Explain a linked cube?
Explain what is fact less fact table? Where you have used it in your project?
The same tier?
What is core dimension?
Explain what are the various transformation available?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
