Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56446 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
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
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is meant by active and passive transformation?
What is a rank transform?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Mention few power centre client applications with their basic purpose?
What is the difference between stop and abort in informatica
What is Cognos script editor?
Where are the source flat files kept before running the session?
To import the flat file definition into the designer where should the flat file be placed?
Write the advantages of partitioning a session?
Why is sorter an active transformation?
How you prepared reports for OLAP?
How many number of sessions can one group in batches?
What happens when a session fails and you click on recover?
What is the difference between STOP and ABORT options in Workflow Monitor?
