What is the difference between view and materialised view?
- 6 Answers
- 12518 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepika
a view is like window through which we can acess the data.
it doesnot store the data,where as materialized view can
contain data also.this can be used for pre computed complex
calulations.
materialized views are called snapshots before oracle 9i
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to update source definition?
What are the modules in Power Center
How do you handle two sessions in Informatica
What is the need of an ETL tool?
tell me 5 session failure in real time how can you solve that in your project?
What is a node in Informatica?
How to elaborate powercenter integration service?
How to join three sources using joiner?
What is complex mapping?
Explain load alternative records / rows into multiple targets - informatica
what is degenerated dimension?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain Dataware house architecture .how data flow from intial to end?
