Why are OLTP database designs not generally a good idea for a Data Warehouse

Question:Why are OLTP database designs not generally a good idea for a Data Warehouse?

Answer: <br><b>Answer posted by Shri Dana on 2005-04-06 19:04:05:</b> OLTP cannot store historical information about the organization. It is used for storing the details of daily transactions while a datawarehouse is a huge storage of historical information obtained from different datamarts for making intelligent decisions about the organization.

Tags:Interview Questions, Data Warehouse, Basics,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

Human Resource Management Software

Powerful, configurable software for human resources management that is easy to manage and remarkably cost-effective, whatever the size of your company. Now there’s a smarter, more efficient way to handle all of your people-related activities. Easy-to-use system manages the full hire-to-retire lifecycle...