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