Oracle Extract transform load (ETL) Question:

What is a three tier data warehouse?

Oracle ETL Interview Question
Oracle ETL Interview Question

Answer:

A data warehouse can be thought of as a three-tier system in which a middle system provides usable data in a secure way to end users. On either side of this middle system are the end users and the back-end data stores.


Previous QuestionNext Question
What is a staging area? Do we need it? What is the purpose of a staging area?What are the various methods of getting incremental records or delta records from the source systems?