Forum Stats

  • 3,825,176 Users
  • 2,260,477 Discussions
  • 7,896,431 Comments

Discussions

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

Rajneesh S-Oracle
Rajneesh S-Oracle Posts: 408 Employee

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