Whatis the difference between View and Materialized View ?
Answer Posted / navas
View:It is a sql query which is executed and populates
results each time when the particular view is accessed.When
we make a DML statement in view it will affect the original
data available in datebase table.
Materialized view:Materialized view is similar to a table
that exists in the table space.The resultsets are fetched
and populated in materialized view from various table when
a meterialixed view is created and will be availabe until
the view is refreshed.
Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What are the types of lookup transformation?
What is standalone command task?
What are the types of schemas we have in data warehouse and what are the difference between them?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the components of the workflow manager?
How many ways are there to create ports?
Explain the types of lookup transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the advantage of informatica?
What is enterprise data warehousing?
What is InformaticaPowerCenter?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What are the components of Informatica? And what is the purpose of each?
What is parallel processing in informatica?
How to elaborate tracing level?