This content has been marked as final.
Show 1 reply
-
1. Re: Partial External Materialization
rareddy May 15, 2015 8:07 AM (in response to jkhoury)John,
Yes, see https://docs.jboss.org/author/display/TEIID/System+Procedures
Since Teiid does not have any control over data changes in the source systems independently, it is an issue to figure out what has been changed. If you have some kind of triggers on source tables, or have a timestamp on every table row when they get updated, you can capture what has been changed since a last refresh and issue a updateMatView request for incremental update. The alternatives are expensive propositions like Oracle Golden gate product etc.
BTW, we do want to improve overall process here with external materialization, so, if you got any additional ideas that can this easier, lets talk about them, and we will consider for implementation.
Ramesh..