What is the difference between view and materialised view?
- 4 Answers
- 11985 Views
- I also Faced
- E-Mail Answers
Answer Posted / sindhu
View - store the SQL statement in the database and let you
use it as a table. Every time you access the view, the SQL
statement executes.
Materialized view - stores the results of the SQL in table
form in the database. SQL statement only executes once and
after that every time you run the query, the stored result
set is used. Pros include quick query results
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain sessions?
update strategy transformation in informatica
What is xml source qualifier transformation in informatica?
Enlist the tasks for which source qualifier transformation is used.
In which transformation you cannot drag ports into it?
How can you increase the performance in joiner transformation?
What are pre and post-session shell commands?
What is meant by lookup transformation? Explain the types of lookup transformation?
what is the complex transformation you used in informatica
difference between repository database and repository service?
Explain the tuning lookup transformation - informatica
How do you remove duplicate records in informatica? And how many ways are there to do it?
On which transformations you created partitions in your project?
What is the meaning of up gradation of repository?
Partition, what happens if the specified key range is shorter and longer
