GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica
Go To First  |  Previous Question  |  Next Question 
 Informatica  |  Question 142 of 629    Print  
what are the difference between view and materialized view?

  
Total Answers and Comments: 21 Last Update: September 15, 2006     Asked by: sarath 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
  Sorting Options  
  Page 1 of 3   « First    1    2    3    >     Last »  
September 30, 2005 00:34:20   #1  
khadarbasha Member Since: September 2005   Contribution: 2    

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

Materialized views are schema objects that can be used to summarize, precompute, replicate, and distribute data. E.g. to construct a data warehouse.

A materialized view provides indirect access to table data by storing the results of a query in a separate schema object. Unlike an ordinary view, which does not take up any storage space or contain any data


 
Is this answer useful? Yes | No
October 04, 2005 01:14:24   #2  
ravi        

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

view is a tailriad representaion of data,its access data from existing table,it have logical structure,cant space occupation.

but meterailzedview stores precaluculated data, its have physical structure, space occupation


 
Is this answer useful? Yes | No
October 04, 2005 23:22:33   #3  
ravikumar guturi        

RE: what are the difference between view and materiali...
view is a tailraid representation of data, but metereialized view is stores precaluculated data, view is a logical structure but mview is physical structure, view is cant occupie the space bu mview is occpies space.
 
Is this answer useful? Yes | No
October 05, 2005 15:55:16   #4  
Sridhar        

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

Diffence between View Materialized view

If you (Change) update or insert in view the corresponding table will affect. but changes will not affect materialized view.


 
Is this answer useful? Yes | No
October 11, 2005 06:30:06   #5  
prasad nallapati        

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.


 
Is this answer useful? Yes | No
October 13, 2005 16:13:16   #6  
venk        

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.


 
Is this answer useful? Yes | No
October 27, 2005 06:29:37   #7  
manjunath        

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

view- the select query is stored in the db. whenever u use select from view, the stored query is executed. Effectively u r calling the stored query. In case u want use the query repetadly or complex queries, we store the queries in Db using View.

where as materialized view stores the data as well. like table. here storage parameters are required.


 
Is this answer useful? Yes | No
November 03, 2005 13:49:03   #8  
kalavlag        

RE: what are the difference between view and materiali...
A view is just a stored query and has no physical part. Once a view is instantiated, performance can be quite good, until it is aged out of the cache. A materialized view has a physical table associated with it; it doesn't have to resolve the query each time it is queried. Depending on how large a result set and how complex the query, a materialized view should perform better.
 
Is this answer useful? Yes | No
November 04, 2005 08:23:08   #9  
swati        

RE: what are the difference between view and materiali...
In materialized view we cann't perform DML operation but the reverse is true in case of simple view.
 
Is this answer useful? Yes | No
November 04, 2005 08:28:12   #10  
swati        

RE: what are the difference between view and materiali...
In case of materialised view we can perform DML but reverse is not true in case of simple view.
 
Is this answer useful? Yes | No
  Page 1 of 3   « First    1    2    3    >     Last »  


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape