Interview Questions

What is a three-tier data warehouse? - ETL

ETL (extract, transform, and load) Testing Interview Questions

(Continued from previous question...)

51. What is a three-tier data warehouse? - ETL

Most data warehouses are considered to be a three-tier system. This is essential to their structure. The first layer is where the data lands. This is the collection point where data from outside sources is compiled. The second layer is known as the ‘integration layer.’ This is where the data that has been stored is transformed to meet company needs. The third layer is called the ‘dimension layer,’ and is where the transformed information is stored for internal use.

(Continued on next question...)

Other Interview Questions