Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between view and materialised view?
- 6 Answers
- 14454 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhabna
1.Basically Materialize view is used as the local copy of a
remote table.So instead of using a remote table,we use M-
View to avoid the network trafic.
2. One of the most prominent feature of M-view is "ENABLE
QUERY REWRITE" clause.It is a query optimization
technique that transforms a user query written in terms of
tables and views, to execute faster by fetching data from
materialized views. It is completely transparent to the end
user, requiring no intervention or hints in the SQL
application because the Oracle9i server will automatically
rewrite any appropriate SQL application to use the
materialized views.
Where as view doesn't contain any such type of clause
3.View doesn't contains any data where as M-View does
4.View reflects the data whenever thae base table is
updated but M-view doesn't reflect that untill it is
refreshed.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
differences between service based and product based?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the different types of transformation available in informatica.
define galaxy repository in informatica
Enlist few areas or real-time situations where informatica is required.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the advantages of using informatica as an etl tool over teradata?
What is pmcmd command?
What is a snowflake schema?
What are pre and post-session shell commands?
Explain the informatica workflow?
During the running session, output files are created by informatica server. Enlist few of them.
