Oracle Extract transform load (ETL) Question: Download Questions 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.
Download Oracle ETL Interview Questions And Answers
PDF
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? |