Interested to Buy Any Domain ? << Click Here >> for more details...
What are materialized views & where do we use them? What is a materialized view log?
- 1 Answers
- 29 Views
- I also Faced
- E-Mail Answers
Answer / Swati Rani
{"Oracle ETL": "Materialized Views (MV) are precomputed, read-only database objects that store the result set of an SQL query. They can improve performance for complex queries by avoiding expensive computations and joins. Materialized views are used in data warehousing, OLAP applications, or when a view is frequently accessed. A Materialized View Log (MVL) records changes to base tables that affect the materialized view, allowing it to be kept up-to-date automatically using the Refresh Fast option."}
| Is This Answer Correct ? | 0 Yes | 0 No |
What are active transformation / passive transformations?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What are materialized views & where do we use them? What is a materialized view?
What are materialized views & where do we use them? What is a materialized view log?
When do you analyze the tables?
What is a staging area? Do we need it?
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)?
I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
Where do we use connected and un connected lookups?
Oracle General 
