Logical Data Warehouse
From the book I Am Datapedia!, published here free by the author.
Part of I Am Datapedia!
Questions 1–10 of 10
1. What is a Logical Data Warehouse (LDW)?
2. What is the backbone of a Logical Data Warehouse?
3. How does a Logical Data Warehouse relate to modelling techniques such as Inmon's 3NF or Kimball's star and snowflake schemas?
4. What does pushdown processing mean in a Logical Data Warehouse?
5. In practical terms, how does a Logical Data Warehouse present itself to users?
6. Which of the following is a governance advantage of a well-implemented Logical Data Warehouse?
7. Why is a Logical Data Warehouse less suitable for regulatory reporting, auditing and long-term trend analysis?
8. What risk arises when a Logical Data Warehouse pushes analytical queries down into operational (OLTP) systems?
9. Why does federated access in a Logical Data Warehouse raise security concerns?
10. How should a Logical Data Warehouse be positioned relative to a physical data warehouse?