What is the difference between a W/H and an OLTP application?
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 data warehosuing hierarchy?
I have two universes created by two difference database can we join them in designer & report level? How
Explain me what are data marts?
What are components of reportnet?
What is the difference between a primary and secondary actor in use case modeling?
What is cost benefit analysis (cba)?
Explain how are the dimension tables designed?
What are Aggregate tables?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Explain what is the difference between view filter and report filter?
Explain what are the steps to build the data warehouse?
What is data warehouse architecture?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Can you state some of the innovations throughout history?
Explain what is full load & incremental or refresh load?