What is a Data Warehouse? - ETL

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

(Continued from previous question...)

37. What is a Data Warehouse? - ETL

A Data Warehouse is a collection of data marts representing historical data from different operational data source (OLTP). The data from these OLTP are structured and optimized for querying and data analysis in a Data Warehouse.

(Continued on next question...)

Other Interview Questions

• What are active and passive transformations? - ETL
• What are the characteristics of a Data Warehouse? - ETL
• What are the characteristics of a Data Warehouse? - ETL
• What is the difference between dimensional table and fact table? - ETL
• What is tracing level? How many types of transformations supported by sorted input? - ETL
• What are Update Strategy’s target table options? - ETL
• What are the differences between Connected and Unconnected lookup? - ETL
• What does a Mapping document contains? - ETL
• What are Confirmed Dimensions? - ETL
• What is ETL (extract, transform, and load) Testing?
• More...