Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56499 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / harshakore
A view has a logical existence but a materialized view has
a physical existence.Moreover a materialized view can be
indexed,analysed and so on....that is all the things that
we can do with a table can also be done with a materialized
view.
| Is This Answer Correct ? | 110 Yes | 5 No |
Post New Answer View All Answers
What are the main features of Oracle 8i with context to datawarehouse?
Explain in detail scd type 2 through mapping.
How do we call shell scripts from informatica?
What do you mean by worklet?
How to create Target definition for flat files?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is resilience time?
How do you set a varible in incremental aggregation
How an expression transformation differs from aggregator transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are the new features of informatica 9.x developer?
How to load the data from a flat file into the target where the source flat file name changes daily?
What is meant by incremental aggregation?
What are the new features of informatica 9.x at the developer level?
