Why should you put your data warehouse on a different system than your oltp system?
- 1 Answers
- 1104 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
