Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 4 Answers
- 13010 Views
- I also Faced
- E-Mail Answers
Answer Posted / anju
materialized view can be used to precalculate the expensive
joins and aggregates prior to execution and the result is
stored in a table in database and can refer to it in
future. the adv of this is increse in performance.
view is nothing but an sql query stored. it will not store
data in tables
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What is the way to execute pl/sql script using informatica mapping?
What is an active transformation?
EXL informatica Questions
What are Dimensional table?
How to create a non-reusable instance of reusable transformations?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is joiner transformation in informatica?
Enlist the advantages of informatica.
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is informatica powercenter repository?
What are active transformations.
Can we create a node as a gateway node and the same node can be assigned to a grid?
How will the document be delivered to me?
What do you mean by blocking transformation?
