1 Reply Latest reply on Dec 12, 2014 10:08 AM by Ramesh Reddy

    External "materialized views based" on multiple "External materialized views"

    Joseph CHIDIAC Novice

      Hi,

      it's possible to  create "materialized views based"  based on multiple "materialized views based" ?

       

      if yes, there is a way to configure the refresh data of the final "materialized views based" ?

        • 1. Re: External "materialized views based" on multiple "External materialized views"
          Ramesh Reddy Master

          yes, you can. Note that when you materialize a view, the table backing it is a "source table". If you want to use that source table as transformation in the another view it should be OK.  However, what is not clear is, if you used the "Materialized View" table in transformation of the second Materialized View. Even in this case the data intially retrieved from the base materialized table then cached in its own table.

           

          The update will not update the base, so they need to be orchestrated such that base is loaded first then derived one for refresh.