Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a W/H and an OLTP application?
- 5 Answers
- 11675 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
Why should you put your data warehouse on a different system than your oltp system?
What is the main difference between star and snowflake star schema? Which one is better and why?
Explain what are fact, dimension, and measure?
what type of raid setup would you put your tx logs?
What is recovering sessions?
What is difference macros and prompts?
What is a staging area? Do we need it? What is the purpose of a staging area?
Difference between cold fusion 5 and cold fusion mx 6?
What are Non-additive facts?
What is factless fact tables?
Explain dimensional modelling?
Explain which columns go to the fact table and which columns go the dimension table?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is "method/1"?
What is data validation strategies for data mart v?
