Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13079 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen kumar pendekanti
In view if we do any operation that may be changes in table
and viveversa.View dont have memery allocation.if we create
a view as 'v1' on emp table and then we delete the emp
table there by 'v1' name will be exist in view list, but
data will not be there, if we create the emp table once
again it will automatically link to that 'v1'view.
But in the case of M.views the changes that made in table
cannot be seen in M.view.M.views have separate memery
allocation if we delete the table the M.view will be there.
M.view is read only view,D.D.L oerations are not possible
on this M.view. M.view are used in dataware housing.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
Where can we find the throughput option in informatica?
what are the Methods For Creating Reusable Transformations?
How many number of sessions can one group in batches?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the size of u r source(like file or table)?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to create the source and target database connections in server manager?
Explain the features of connected and unconnected lookup.
Quickly characterize reusable change?
What is a difference between complete, stop and abort?
Write the unconnected lookup syntax?
What is a surrogate key?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the various types of transformation?
