Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13210 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 flashback table ? Advance thanks
What is dynamic cache?
State the limitations where we cannot use joiner in the mapping pipeline?
Explain the shared cache and re-cache?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to create a non-reusable instance of reusable transformations?
What are the databases that informatica can connect to windows?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you load only null records into target? Explain through mapping flow.
What are the different versions of informatica?
Explain transaction control transformation in informatica
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is update strategy transform?
Why is sorter an active transformation?
what is the -ve test case in your project.
