Add support for creating partitioned views
------------------------------------------
Key: TEIIDDES-1198
URL:
https://issues.jboss.org/browse/TEIIDDES-1198
Project: Teiid Designer
Issue Type: Feature Request
Components: Modeling
Reporter: Steven Hawkins
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