-
Type:
Enhancement
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: 10.0.2
-
Fix Version/s: 10.0.2
-
Component/s: Modeling
-
Labels:
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......),'
but do add the double tic's inside the native call