What is the difference between view and materialised view?
- 4 Answers
- 11735 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
if we have a delimiters at unwanted places in a flat file how can we over come those.
waht type of interface is used for testing the data in informatica
How would you join a node to the already existing domain?
What is expression transformation?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can anyone tell me the new features in Informatica 9 Version?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
tell me about your project functionality
Explain constraint based loading in informatica
What is Cognos script editor?
What are the new features of informatica 9.x developer?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a pre-defined event and user-defined event?
Differentiate between router and filter transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
