DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

Why are OLTP database designs not generally a go

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

Since in OLTP,tables are normalised and hence query response will be slow for end user and OLTP doesnot contain years of data and hence cannot be analysed.

(Continued on next question...)

Other Job Interview Questions