Interested to Buy Any Domain ? << Click Here >> for more details...
What are materialized views & where do we use them? What is a materialized view?
- 1 Answers
- 34 Views
- I also Faced
- E-Mail Answers
Answer / Naresh Sharma
A materialized view (MV) in Oracle ETL is a database object that contains pre-computed query results, which can significantly improve the performance of complex queries. Materialized views are useful when you need to frequently run reports on data that does not change often or takes a long time to process. The data in a materialized view is refreshed periodically using a refresh procedure. By caching the result set as a table, materialized views can provide faster query response times and improved performance for large data sets.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you analyze the tables
What are active transformation / passive transformations?
What are parameter files? Where do we use them?
How to determine what records to extract?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
When do you analyze the tables?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
What is the purpose of a staging area?
What are the various tools? - Name a few?
What are materialized views & where do we use them? What is a materialized view?
What is a staging area? Do we need it?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Oracle General 
