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
List down some of the real time data-warehousing tools?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Name a few sectors which use data warehousing?
How to stop a batch?
Explain the differences between normalizer and normalizer transformation?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What is a fact, dimension, measure?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
What is the advantages data mining over traditional approaches?
Explain ddl (data definition language)?
Explain about core dimension,
explain about dirty dimension?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is data warehosuing hierarchy?
What needs to be done when the database is shutdown?