[JBoss JIRA] (TEIIDDES-2970) Set default MatView Extension Properties for JDG materialization
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2970?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2970:
--------------------------------------
Assignee: Barry LaFond
> Set default MatView Extension Properties for JDG materialization
> ----------------------------------------------------------------
>
> Key: TEIIDDES-2970
> URL: https://issues.jboss.org/browse/TEIIDDES-2970
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Modeling
> Affects Versions: 10.0.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
>
> When a view is being materialized for JDG, set the following extension properties:
> <vhalbert> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {jdgsourcemodelname}.native(''swap cache names'');'
> <vhalbert> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {jdgsourcemodelname}.native(''truncate cache'');',
> where {jdgsourcemodelname} as the new JDG Source Model that is created.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2971) Create Primary and Foreign Keys when JDG materialization is creatd
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2971:
-------------------------------------
Summary: Create Primary and Foreign Keys when JDG materialization is creatd
Key: TEIIDDES-2971
URL: https://issues.jboss.org/browse/TEIIDDES-2971
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 10.0.2
Reporter: Van Halbert
When a view is being materialized for JDG, the following keys need to be created:
- as part of the cacheTypeMap property, the 3rd parameter primary key column: (cacheName:ClassName:primarykeycolumn)
a primary key should be made containing that column on both of the newly created tables.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2970) Set default MatView Extension Properties for JDG materialization
by Van Halbert (JIRA)
Van Halbert created TEIIDDES-2970:
-------------------------------------
Summary: Set default MatView Extension Properties for JDG materialization
Key: TEIIDDES-2970
URL: https://issues.jboss.org/browse/TEIIDDES-2970
Project: Teiid Designer
Issue Type: Enhancement
Components: Modeling
Affects Versions: 10.0.2
Reporter: Van Halbert
When a view is being materialized for JDG, set the following extension properties:
<vhalbert> "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute {jdgsourcemodelname}.native(''swap cache names'');'
<vhalbert> "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute {jdgsourcemodelname}.native(''truncate cache'');',
where {jdgsourcemodelname} as the new JDG Source Model that is created.
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 11 months