Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2970

Set default MatView Extension Properties for JDG materialization

    XMLWordPrintable

    Details

      Description

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                blafond Barry LaFond
                Reporter:
                van.halbert Van Halbert
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: