Why should you put your data warehouse on a different system than your oltp system?
- 1 Answers
- 1110 Views
- I also Faced
- E-Mail Answers
Answer / Gautam Sinha
"Putting your data warehouse on a different system than the OLTP system is recommended because it separates operational and analytical workloads, reduces contention for resources, improves performance of both systems, allows easier management of data transformation processes, and provides better data consistency."
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a real-time data warehouse?
What are the various methods of getting incremental records or delta records from the source systems?
Explain about core dimension, balanced dimension, and dirty dimension?
How to answer the question how many fakt table in your datawarehouse and what size it have?
What are data modeling and data mining?
What are target types on the server?
What is a functional dependency f said to be minimal?
what are the similarities between ROLAP and MOLAP
What is Cognos script editor?
Explain normalization?
Difference between cold fusion mx 6 and cold fusion mx 7?
Explain what are data marts?
Teradata 
