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

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



October 10, 2005 01:14:24 #2
 ravi   Member Since: Visitor    Total Comments: N/A 

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

     

 

Back To Question