Hi All,
We have a source schema and Target schema in the same database.
I have a query on source schema tables which pulls million records.
Now, I have created a table in target schema and I need to push this data into the table like an ETL sort of thing.
Materialized views are best solution available for this, but unfortunately we can't use Materialized views due to some restrictions and access grant issues.
So, I wrote a merge query inside a procedure and used the scheduler to execute the procedure every one minute.
This is serving the purpose, but every minute it is updating all the million rows even if only 10 rows are only changed in the source.
Is there any way to only update the changes and not all the matched rows.
Kindly suggest.
Regards,
Sail.