Whatis the difference between View and Materialized View ?
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
How do you load only null records into target?
Slowly changing dimensions, types and where will you use them
What does refresh system mean, and what are its distinctive choice?
How can repository reports be accessed without sql or other transformations?
What are the types of data warehouses?
scenario where i can use only concurrent execution of workflow.
What is an unconnected transformation?
What is the need for an etl tool?
Differences between connected and unconnected lookup?
How to go to the older version for a mapping?
In development project what is the process to follow for an etl developer from day1
How to configure mapping in informatica?
Explain your project of banking domian.
What are pre and post-session shell commands?
How can one identify whether mapping is correct or not without connecting session?