Chapter 4. Using the cube model for summary tables optimization 203
4.9.5 Implementation guidelines
MQTs can be used for many other purposes such as for example materialize
SQL transformations on ETL process; on this documentation we are limiting our
discussion on building MQTs to support business intelligence applications and
more specifically for query reporting and DB2 Cube Views. For more details on
how to implement MQTs, please refer to
DB2 UDB’s High Function Business
Intelligence in e-business
, SG24-6546.
The current version of DB2 Cube Views only generates scripts to perform FULL
refresh on the MQT. If you plan to have MQTs incrementall ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.