General Datawarehousing Question:
Download Questions PDF

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

Answer:

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.

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are conformed dimensions?How to load the time dimension?