Does anyone have experience using incremental materialized views in a data warehouse. Right now all our materialized views are Complete as opposed to Incremental. The incremental would use resources during the loading process.
1. Can you delay the incremental build until the ETL process finishes?
2. Is it a big resource hit when the data is batch loaded in the underlying tables?
3. Is it possible to build the MV on one server using SQL that points to the other server and then copy the MV back to the first server when finished with incremental build?
1. Can you delay the incremental build until the ETL process finishes?
2. Is it a big resource hit when the data is batch loaded in the underlying tables?
3. Is it possible to build the MV on one server using SQL that points to the other server and then copy the MV back to the first server when finished with incremental build?
