Question: what is the difference between data warehouse and oltp?
Answer: One major difference between the types of system is that data warehouses are not usually in third normal form (3NF), a type of data normalization common in OLTP environments. Data warehouses are designed to accommodate ad hoc queries and data analysis. ... OLTP systems support only predefined operations.