[
https://issues.jboss.org/browse/TEIIDDES-2970?page=com.atlassian.jira.plu...
]
Van Halbert updated TEIIDDES-2970:
----------------------------------
Description:
When a view is being materialized for JDG, set the following extension properties:
teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT -
{code}
execute {jdgsourcemodelname}.native(''swap cache names'');
{code}
teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT -
{code}
execute {jdgsourcemodelname}.native(''truncate cache'');
{code}
teiid_rel:MATERIALIZED_STAGE_TABLE -
{code}
{jdgsourcemodelname}.{stagingTable}
{code}
where {jdgsourcemodelname} as the new JDG Source Model that is created.
note: do not add tic's around these, like 'execute......),'
was:
When a view is being materialized for JDG, set the following extension properties:
teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT -
execute {jdgsourcemodelname}.native(''swap cache names'');
teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT -
execute {jdgsourcemodelname}.native(''truncate cache'');
teiid_rel:MATERIALIZED_STAGE_TABLE -
{jdgsourcemodelname}.{stagingTable}
where {jdgsourcemodelname} as the new JDG Source Model that is created.
note: do not add tic's around these, like 'execute......),'
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
Fix For: 10.0.2
When a view is being materialized for JDG, set the following extension properties:
teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT -
{code}
execute {jdgsourcemodelname}.native(''swap cache names'');
{code}
teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT -
{code}
execute {jdgsourcemodelname}.native(''truncate cache'');
{code}
teiid_rel:MATERIALIZED_STAGE_TABLE -
{code}
{jdgsourcemodelname}.{stagingTable}
{code}
where {jdgsourcemodelname} as the new JDG Source Model that is created.
note: do not add tic's around these, like 'execute......),'
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)