SQL & PL/SQL

Hi,

I have big source tables to load in a datawarehouse. We are in a full Oracle environnement.
So I need to extract only delta since the last extract.

I need to capture even deleted rows from the source table.

I have tested the following solution:
- declare a materialized view log on the source table
- load the content on this view log in my ODS
- empty this view log
- load my DWH with the captured delta

It is very simple and seems to work perfectly.

I am just confused by the fact that nobody seems to have implemented such a solution.

Could anyone tell us if this is a classic use case ?

Thanks.

Regards