Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 12880 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 is confirmed fact in dataware housing?
What is the status code in stored procedure transformation?
How to load a Dimension ? and how to load a fact table?
Can we get 1st record through Informatica(without sequence number).
What is a mapplet/worklet in informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is primary and backup node?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How is union transformation utilized?
can we override a native sql query within informatica? How do we do it?
What is the difference between a connected look up and unconnected lookup?
tell me about your project functionality
Which are the different editions of informatica powercenter that are available?
how many types of dimensions are available in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
