Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56785 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / navas
View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
complex mapping ur project u r invlve can u explain and give real time example give me ?
Whats there in global repository
How we can create indexes after completing the load process?
Global and Local shortcuts. Advantages.
Define joiner transformation?
Write the prerequisite tasks to achieve the session partition?
Define enterprise data warehousing?
What is expression transformation?
What are the main features of Oracle 8i with context to datawarehouse?
what is SDLC way of code development?
What is meant by lookup transformation? Explain the types of lookup transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is blocking transformation?
Write the advantages of partitioning a session?
