What is the difference between view and materialised view?
- 4 Answers
- 11986 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 clients of powercenter?
Why do we need informatica?
Define pmcmd command?
Please let me know how to make encryption and decryption with example?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the components of workflow manager?
What do you mean by blocking transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Define mapplet?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the use of code page?
scenario where i can use only concurrent execution of workflow.
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
