[ https://issues.jboss.org/browse/TEIIDDES-1198?page=com.atlassian.jira.plu... ] Steven Hawkins updated TEIIDDES-1198: ------------------------------------- Description: As an alternative to multi-source models, Teiid supports updatable views defined as union alls that serve the same purpose. It would be good if there was something that could guide the user in creating a partitioned view layer. For example after source A and source B have been imported (of course there could be more than two sources) there could be a modeling option in the new model wizard that creates a view layer not from a single source, but multiple sources. The views would be defined as select 'sourceA' as source_name, ... from sourceA.tbl union all select 'sourceB' as source_name, ... from sourceB.tbl. Obviously without a reconciliation step we would expect tables and column names to match exactly. Procedures are a special case and don't quite fit cleanly in this approach (or in mulit-source logic either). was: As an alternative to multi-source models, Teiid supports updatable views defined as union alls that serve the same purpose. It would be good if there was something that could guide the user in creating a partitioned view layer. For example after source A and source B have been imported (of course there could be more than two sources) there could be a modeling option in the new model wizard that creates a view layer not from a single source, but multiple sources. The views would be defined as select ... from sourceA.tbl union all select ... from sourceB.tbl. Obviously without a reconciliation step we would expect tables and column names to match exactly. Procedures are a special case and don't quite fit cleanly in this approach (or in mulit-source logic either). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira