Unanswered: MQT - Staging table not getting populated when base table is loaded
i try to implement MQT , and refresh the MQT from the staging table. I use the following commands to create a MQT , create a staging table with "propagate immediate" option and refresh it. But when i load the base table, the staging table is not populated automatically.
CREATE TABLE SALES_BY_TRANSID AS
( SELECT TRANSID, COUNT(*) AS ITEM_COUNT, SUM(AMOUNT) AS TOTAL
GROUP BY(TRANSID) )
DATA INITALLY DEFERRED
CREATE TABLE STG_SALES_BY_TRANSID FOR SALES_BY_TRANSID PROPAGATE IMMEDIATE;
REFRESH TABLE SALES_BY_TRANSID;
Then i inserted some data into the base table "TRANSITEM" . But i find that - the staging table is not getting populated at all.
did i miss out anything here?
can anyone tel me the reason why it is not populating automatically, and also the resolution for it?