Answer Detail: RE: what are the difference between view and materiali...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: what are the difference between view and materialized view?

October 10, 2005 06:30:06	#5
prasad nallapati	Member Since: Visitor Total Comments: N/A
RE: what are the difference between view and materiali...
materialized views to store copies of data or aggregations.Materialized views can be used to replicate all or part of a single table, or part of single table, or to replicate the result of a query against multiple tables.refreshes of the replicated daa can be done automatically by the database at time intervals.