Can we define an Incremental MQT having clause COUNT(DISTINCT. .)???
I am facing the issue while creating the Staging Table for one of the MQTs which has this clause in it's definition.I am able to create the same inrcremental MQT with the Staging Table by removing the clause...
Is there any way around to overcome the problem???
Thanks..
Ramesh K.
Rameshk
Last Activity: Nov 28 '12, 09:39 AM
Joined: Nov 19 '12
Location:
-
COUNT(DISTINCT...) Clause in IMMEDIATE REFRESH MQTs
-
Thanks for the response.
I implemented it for my application and it's working fine. -
MQT over multiple table and Incremental Refresh
Can we have MQT defind over multiple tables having staging table to enable incremental refresh and the Queries on the underlying table redirected to the MQT???
No activity results to display
Leave a comment: