
208 DB2 Cube Views: A Primer
Table 4-10 FULL refresh on refresh DEFERRED/ IMMEDIATE
MQTs
INCREMENTAL maintenance of refresh IMMEDIATE MQTs
MQTs defined as refreshed IMMEDIATE can be incrementally maintained via
inserts/updates/delete on which changes (delta) are propagated immediately or it
can also be incrementally maintained via the
Load Insert utility on which
changes (delta) are not propagated immediately.
Since
Load Insert is a more common implementation for Business Intelligence
applications, we are only covering the process to incrementally maintain MQTs
using the Load Insert option.
Step # Step definition Considerations
1 DROP TABLE <mqt>; ...