Using Materialized View as ETL option to populate data from OLTP to OLAP

Rajneesh S-Oracle

Hello All,

Any comment regarding Using Materialized View as ETL option to populate data from OLTP to OLAP? Pros and Cons will be useful.

One problem I understand that on commit refresh will put performance burden on OLTP source due to frequent updates on log files (change data capture), however it should not be a concern in case of scheduled refresh?

Thanks,

Rajneesh