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 Question | Next Question |
Explain What are conformed dimensions? | How to load the time dimension? |