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


Please Help Members By Posting Answers For Below Questions

have u done any performance tuning? how u ll do?

2090


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1736


complex mapping ur project u r invlve can u explain and give real time example give me ?

2088


What are mapplets?

1034


Explain sessions. Explain how batches are used to combine executions?

807


What is the difference between STOP and ABORT options in Workflow Monitor?

970


 Informatica Checkpoints

3097


How are indexes created after completing the load process?

1268


How we can use union transformation?

836


Write the prerequisite tasks to achieve the session partition?

864


Implementation methodology

1504


What are data-driven sessions?

977


What is an active transformation?

863


Why do you use Mapping Parameter and mapping variable?

1501


Explain the pipeline partition with real time example?

911