materialized views used for low footprint ETL ?

From: Jack <jack_posemsky_at_yahoo.com>
Date: 12 Jul 2005 21:46:02 -0700
Message-ID: <1121229962.342660.232190@g14g2000cwa.googlegroups.com>

Hi,

In a data warehousing scenario is it possible to use a materialized view to pull data via a query from a remote source system with no footprint other than the direct query ?
Or, is it true that materialzed views are always a "push" model that involves overhead on the source system (as opposed to mviews when operated remotely over dblink having no footprint and "pull" the data) ?

I believe, but cant back it up, that if an mview was created as an 'ON DEMAND' 'COMPLETE REFRESH' Materialized View, I can't find any reason that why an mview couldnt PULL the data from a remote source system and the footprint on your Source DB would be more than the execution of the query and returning all of the data. (I am not talking about the execution of a SQL view over a dblink which is a remote query)

Can anyone provide some Oracle documentation that backs up the notion... ?

Thank you,

Jack Received on Tue Jul 12 2005 - 23:46:02 CDT