Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56080 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
Can we get 1st record through Informatica(without sequence number).
What is different between the data warehouse and data mart?
Tell me about Propagate functions in informatica
Explain the use of aggregator cache file?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the need for an etl tool?
write a query to retrieve the latest records from the table sorted by version(scd)
what is the Default Source Option For Update Strategy Transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Define enterprise data warehousing?
Where is metadata stored?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the different options available for update strategy?
How do you convert single row from source into three rows into target?
What is the function of aggregator transformation?
