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
have u done any performance tuning? how u ll do?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
complex mapping ur project u r invlve can u explain and give real time example give me ?
What are mapplets?
Explain sessions. Explain how batches are used to combine executions?
What is the difference between STOP and ABORT options in Workflow Monitor?
Informatica Checkpoints
How are indexes created after completing the load process?
How we can use union transformation?
Write the prerequisite tasks to achieve the session partition?
Implementation methodology
What are data-driven sessions?
What is an active transformation?
Why do you use Mapping Parameter and mapping variable?
Explain the pipeline partition with real time example?