OLTP 3NF vsData Warehouse 3NF
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What common assumption causes confusion between OLTP 3NF and data warehouse 3NF?
2. What is the primary objective of an OLTP 3NF system?
3. In an OLTP 3NF system, what happens when a customer changes their address?
4. Which philosophy is dominant in a 3NF data warehouse?
5. Which question can a data warehouse answer that an OLTP system typically cannot?
6. How does Slowly Changing Dimension (SCD) Type 2 differ from Type 1?
7. Does the Slowly Changing Dimension philosophy apply to 3NF data warehouses, or only to dimensional models?
8. Which of the following is characteristic of data warehouse 3NF rather than OLTP 3NF?
9. What is the risk of designing a data warehouse like an OLTP system?
10. According to the strategic insight on OLTP 3NF versus data warehouse 3NF, what is the true differentiator between the two?