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 the difference between Datawarehouse and OLAP?
What is the difference between static cache and dynamic cache?
What are the different types of fact tables used in data warehousing?
Explain what is the difference between stop and abort?
Explain difference between data ware house & data mart?
What is called data cleaning?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How to reduce warnings?
I need to set predefined condition. How I do this?
What are fundamental stages of data warehousing?
Explain what is analytical or analytic mean?
What is difference macros and prompts?
Ist the schema that a data warehouse system can implements.
What are the various tools? Explain name a few?
Explain conformed fact?