Interested to Buy Any Domain ? << Click Here >> for more details...
Whatis the difference between View and Materialized View ?
- 11 Answers
- 56090 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / anju
A materialized view is a stored summary containing pre-
computed results.As the data is pre-computed, materialized
views allow for faster query answers
In warehousing applications, large amounts of data are
processed and similar queries are frequently repeated. If
these queries are pre-computed and the results stored in
the data warehouse as a materialized view, using
materialized views significantly improves performance
by providing fast lookups into the set of results.
A Materialized View generally behaves like a Index and it
can also have any Number of Aggregates and Joins.
| Is This Answer Correct ? | 37 Yes | 6 No |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How does a sorter cache works?
What is the difference between informatics 7x and 8x and what is latest version?
How to start a workflow using pmcmd command?
How do we call shell scripts from informatica?
how many types of dimensions are available in informatica?
tell me about your project functionality
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is blocking transformation?
Explain in detail about scd type 1 through mapping.
How to join three sources using joiner? Explain though mapping flow.
What are Dimensional table?
What the difference is between a database, a data warehouse and a data mart?
Difference between Data and Index Caches?
What does refresh system mean, and what are its distinctive choice?
