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 16:13:16	#6
venk	Member Since: Visitor Total Comments: N/A
RE: what are the difference between view and materiali...
A view do no derive the change made to it master table after the view is created. A materialized view immediately carries the change done to its mater table even after the materialized view is created.