What is the difference between view and materialised view?
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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How can you define user defied event?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is session task and command task?
What is the need of an ETL tool?
How can you increase the performance in joiner transformation?
What are pre and post-session shell commands?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How many numbers of sessions can one group in batches?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is substr in informatica?
What are roles and groups and benefits of using them?
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 .
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Please let me know how to make Data masking in informatica..