I want to update materialized view in Teiid embedded for data addition/update in source data though listeners running with embedded teiid. Listeners would subscribe events of source data. So matarealized view update is possible?
which kind of materialized view (internal/external) should be used?
what are the criterias for deciding internal and external materialized views?
> what are the criterias for deciding internal and external materialized views?
See Materialized Views - Teiid 8.12 (draft) - Project Documentation Editor and the sub pages for a discussion of each.