Need one help on below:
I have one shell script(script name: s1_load) . Which has been scheduled based on parameters to load data into multiple tables at multiple intervals as below:
Script name schedule_timing parameter load_table_name
s1_load 08:00 mt mt
s1_load 08:30 st st
s1_load 09:00 vt vt
s1_load 09:30 nt nt
Now the requirement is that I need to load data into new materialized views based on above tables. for e.g. load data in mview_sn. which will use tables st and nt. Similarly need to load data in mview_msn which will use tables mt, st, nt.
Also main thing is that I need to load data as when the tables got loaded. for e.g when st and nt got loaded then immediately call should be made to load data in materialized view mview_sn. Similar thing required for mview_sn.
Need your suggestion. what is the best method to achieve this.