0

Trigger MV load after schema load?

Is there a way to automatically trigger a load of a materialized view whenever a scheduled schema load has been completed?  This would basically keep a schema and associated materialized view in sync.

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Bryan Welch the best way to do this is to define the MV within the scheduled schema itself. This guarantees the MV will run as part of the enrichment phase immediately after data extraction is complete. If there exists a chain of dependencies, you can control the order of both table extracts and subsequently MVs within a single schema by editing the load order configuration in the UI. If that is not possible, then offhand I could think of a couple ways that involve scripting and/or command line work but I assume you would want to pursue the first option if feasible.

    Like 1
Like Follow
  • 3 wk agoLast active
  • 1Replies
  • 16Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!