Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13021 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
What are the different options available for update strategy?
How to generate sequence numbers using expression transformation?
How to use procedural logic inside infromatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can we create two repositories on same database instance in oracle?
Is it possible to define a single node as a Gateway node as well as worker node?
How to configure mapping in informatica?
What could be the possible resons of locks by user?
Explain transaction control transformation in informatica
What is persistent lookup cache?
What is an expression transformation in informatica?
Separate from an archive server and a powerhouse?
Scheduling properties,whats the default (sequential)
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is sequence generator transformation in informatica?
