What is the difference between view and materialised view?
Answer Posted / anurag arun edlabadkar
Difference Between Inline View & Materialized View?
You can use Materialized views to pre-aggregate the data
and improve the query performance. When you create a
materialized view, Oracle created a physical table to hold
data that would usually be read via a view. When you create
a materialized view, you specify the view's base query as
well as a schedule for the refreshes of its data. You can
then index the materialized view to enhance the performance
of queries against it. As a result, you can provide data to
your user in the format they need, indexed appropriately.
A View is a database object that is a logical
Representation of of a table. It is derived from a table
but has no storage of its own and often may be used in the
same manner as a table.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Differentiate between source qualifier and filter transformation?
What are the different options available for update strategy?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How union transformation is used?
Mention some types of transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is the difference between router and filter?
Please let me know how to make Data masking in informatica..
How to load the data from people soft hrm to people soft erm using informatica?
In which transformation you cannot drag ports into it?
What is InformaticaPowerCenter?
What is the sequence generator transformation in informatica?
What are the measure objects?
draw informatica architecture 8.6 ?
explan ur project architecture?