Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
Answer:
Materialized view is a view in wich data is also stored in some temp table.i.e if we will go with the View concept in DB in that we only store query and once we call View it extract data from DB.But In materialized View data is stored in some temp tables.
| Previous Question | Next Question |
| What are the various tools? Name a few? | What is fact less fact table? where you have used it in your project? |