Based on TEIID-4628, to work with eager updates on materiliazed view, a materialized view's cached table MUST contain an additional column called "LoadNumber" along with rest of view columns. This column is used track the and update the cache contents according to the
SYSADMIN.updatematView
procedure. The relevant document can be found at https://teiid.gitbooks.io/documents/content/caching/External_Materialization.html
- is related to
-
TEIID-4628 Support incremental materialization refresh strategies
- Resolved
-
TEIIDDES-3010 Add feature to provide adding After Triggers to materialized views/tables
- Resolved
-
TEIID-4627 High-level event handling
- Resolved